| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Row reference formula not working with a VLookup
I am trying to find the row number of data that is found using the VLookup.
=ROW(VLOOKUP(B22,LabRow,1,FALSE)) B22 = a name (name to be looked up in a list to find the row number) LabRow = a list of names to find the name I need the row number of the found name The above formula will not continue states - Formula Error, can any one tell me what is wrong or a formula that will find a row number of a certain criteria in a list. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2002: Vlookup formula not working | Excel Discussion (Misc queries) | |||
| VLOOKUP formula not working. HELP! | Excel Discussion (Misc queries) | |||
| Cell reference in vlookup not working | Excel Worksheet Functions | |||
| VLOOKUP & Dates: Why is this Formula working? | Excel Worksheet Functions | |||
| Excel formula-cell reference not working | Excel Worksheet Functions | |||
Threaded Mode
