Determning the ROW of a vlookup result

M

Markshnier

I am quite familiar with the vlookup function. But, I am stmped in
situation where what I am looking for is not the result of the vlookup
but rather the absolute ROW in the sheet in which the result falls.

For example, say that the result of my vlookuip is a value that lies i
cell 26B.

How do I return the result "26"?

Similarly, what If I wanted to know the Column. How would I return th
result "B"?

thx
Mar
 
B

Bob Phillips

Use MATCH with your value and the whole column

=MATCH(val, lookup_formula,0)

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top