Data Address - Row No.
On Nov 27, 5:00 pm, EricBB wrote:
hi carlo,
this is really what i want. thank you so much
EricBB
"carlo" wrote:
What you need is the Match function:
=MATCH(A1,Sheet1!A:A,FALSE)
And if you want to ignore empty cells:
=if(A1="","",MATCH(A1,Sheet1!A:A,FALSE))
And for ignoring errors:
=IF(A1="","",IF(ISERROR(MATCH(A1,Sheet1!A:A,FALSE) ),"not
found",MATCH(A1,Sheet1!A:A,FALSE)))
hth
Carlo- Hide quoted text -
- Show quoted text -
you're welcome!
|