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