HI...

Is there a way to reference a cell after using Vlookup. IE:

a2 10 b2 d
a3 14 b3 e
a4 39 b4 f


c5 14 d5 = vlookup(c5,a2:b4,2,false) ...result 'd'

Now I want to be able to determine the cell was 'b3'

Thanks!!!


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

=Match(C5,A2:A4,0)
will give you 2 since it is the second cell in the column of cells A2:A4

Since you know the range starts in A2, you could add 1 to that to get row 3
and you already know the value is in column B.

="B" & Match(C5,$A$2:$A$4,0)+1

--
Regards,
Tom Ogilvy

"hef" wrote in message
...

HI...

Is there a way to reference a cell after using Vlookup. IE:

a2 10 b2 d
a3 14 b3 e
a4 39 b4 f


c5 14 d5 = vlookup(c5,a2:b4,2,false) ...result 'd'

Now I want to be able to determine the cell was 'b3'

Thanks!!!


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/