=IF(ISNA(HLOOKUP(A1,F1:Y2,2,FALSE)),HLOOKUP(A1,F3: Y4,2,FALSE),HLOOKUP(A1,F1:Y2,2,FALSE))

Vaya con Dios,
Chuck, CABGx3



"kristyb" wrote:


CLR I used your example and it worked.

HOWEVER, I changed it to Hlookup and it works fine.

What if... on row 1 & 3 I have my numbers 1-40
and on row 2 & 4 I have my prices. How can I make it that it picks up
the table array for row 1&3 and row2&4?


--
kristyb
------------------------------------------------------------------------
kristyb's Profile: http://www.excelforum.com/member.php...o&userid=37311
View this thread: http://www.excelforum.com/showthread...hreadid=570185