Actually, as I have data in multiple rows, the PERFECT solution is....
=HLOOKUP($A$13,$C$1:$F$10,ROW(1:1),TRUE)
Thanks for pointing me in the right direction!!

"jindon" wrote:


Hi,

if you change the formula like

=HLOOKUP($A$13,$C$1:$F$10,ROW(A1),TRUE)

ROW(A1) is the substitute of 1 and it increases as you copy down

is this what you wanted?


--
jindon
------------------------------------------------------------------------
jindon's Profile: http://www.excelforum.com/member.php...o&userid=13135
View this thread: http://www.excelforum.com/showthread...hreadid=376194