| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| European Address Data | Excel Discussion (Misc queries) | |||
| How do I avoid excel change absolute address to relative address | Excel Discussion (Misc queries) | |||
| How do I separate data in address field? | New Users to Excel | |||
| long address list, name-address-city, listed vertically, how do y. | Excel Discussion (Misc queries) | |||
| How do I import Office address book to Outlook Express address bo. | Excel Discussion (Misc queries) | |||
Threaded Mode
