Thread: Row reference formula not working with a VLookup
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roibn L Taylor Roibn L Taylor is offline
external usenet poster
  
Posts: 4
Default 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.
Reply With QuoteReply With Quote