Assuming your data is in B1:D2 and your lookup value in H1 try

=VLOOKUP(H1,OFFSET(B1:C2,,MIN(IF(B1:D2=H1,COLUMN(B 1:D2)-COLUMN($B2)))),2,0)

confirmed with CTRL+SHIFT+ENTER.


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=559612