I've made two example sheets to show my problem.

SHEET A
http://img71.imageshack.us/img71/9950/example010xx.jpg

SHEET B
http://img210.imageshack.us/img210/5...ample024ce.jpg

When i choose a number from 1-3 and type it in the red cell, i'd like
the data from the correct table to be linked too the table in Sheet B.
I can't figure out how to make Excel register the number in the red
cell and then compare it to the number on the tables.

Normally i'd use a simple VLookup, but obviousally that only looks at 1
table, i'd like to be able to have as many tables as i can. Any ideas on
how to get the above problem to work?


--
PhilK
------------------------------------------------------------------------
PhilK's Profile: http://www.excelforum.com/member.php...o&userid=34665
View this thread: http://www.excelforum.com/showthread...hreadid=544338