Determning the ROW of a vlookup result
 

I am quite familiar with the vlookup function. But, I am stmped in a
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 in
cell 26B.

How do I return the result "26"?

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

thx
Mark


--
Markshnier
------------------------------------------------------------------------
Markshnier's Profile: http://www.excelforum.com/member.php...o&userid=16465
View this thread: http://www.excelforum.com/showthread...hreadid=278256

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)


"Markshnier" wrote in message
...

I am quite familiar with the vlookup function. But, I am stmped in a
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 in
cell 26B.

How do I return the result "26"?

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

thx
Mark


--
Markshnier
------------------------------------------------------------------------
Markshnier's Profile:
http://www.excelforum.com/member.php...o&userid=16465
View this thread: http://www.excelforum.com/showthread...hreadid=278256

Instead of lookup use MATCH to find the row

--
Don Guillett
SalesAid Software

"Markshnier" wrote in message
...

I am quite familiar with the vlookup function. But, I am stmped in a
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 in
cell 26B.

How do I return the result "26"?

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

thx
Mark


--
Markshnier
------------------------------------------------------------------------
Markshnier's Profile:
http://www.excelforum.com/member.php...o&userid=16465
View this thread: http://www.excelforum.com/showthread...hreadid=278256