Biff,

Although i dont understand either of your formulas, your answer seems a
bit easier.

Could you explain to me what each section is?

=VLOOKUP(A2,CHOOSE(B1,Tbl1,Tbl2,Tbl3,Tbl4),2,0)

I understand the first half but i get confused on the CHOOSE part. How
does it know what table i want to look from? What does the 2,0 part
do?

Thank you in advance.


--
joeldsmt
------------------------------------------------------------------------
joeldsmt's Profile: http://www.excelforum.com/member.php...o&userid=11889
View this thread: http://www.excelforum.com/showthread...hreadid=560923