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/