| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
A formula enquiry; (screenshots included)
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| assign formula to another cell | Excel Worksheet Functions | |||
| How would I write a max formula that included color formats? | Excel Discussion (Misc queries) | |||
| Match then lookup | Excel Worksheet Functions | |||
| adding row to forumla | Excel Discussion (Misc queries) | |||
| Creating a check mark box | Setting up and Configuration of Excel | |||
Threaded Mode
