Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to lookup the row number
Hiya Experts! I am trying to get a simple formula in Excel to return the row number based on a lookup. I'll try to clarify if this doesn't make sense. I have in cell A1 of Book1 a text. Based on that text I want in cell B1 of Book1 enter the ROW where the same text is in Book2. I guess it's a tweak of vlookup but I fail to return the row number... Many thanks! -- Petitboeuf ------------------------------------------------------------------------ Petitboeuf's Profile: http://www.excelforum.com/member.php...o&userid=10602 View this thread: http://www.excelforum.com/showthread...hreadid=503967 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to lookup the row number
Have you tried the match function If for example your range of data to compare against was c1:c35 MATCH(A1,Sheet2!C1:C35,0) This gives you the row of the first match. If your data started in row5 for example amend the formula MATCH(A1,Sheet2!C5:C39,0)+4. The final 0 in the formula just ensures an exact match A vlookup would work but you would need to add a colum with the numbers in. -- Dav ------------------------------------------------------------------------ Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107 View this thread: http://www.excelforum.com/showthread...hreadid=503967 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to lookup last number in colum | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
How do I replace a negative number at the end of a formula with a. | Excel Discussion (Misc queries) | |||
double lookup, nest, or macro? | Excel Worksheet Functions |