Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
EXCEL - FORMULA TO CREATE A TAB REFERENCE
I WANT TO LOOKUP INFORMATION IN MULTIPLE SHEETS AND WOULD LIKE TO BE ABLE TO
USE A FORMULA TO REFERENCE A CELL IN THE CURRENT SHEET WITH THE SPECIFIC SHEET NAME THAT I WANT TO DO THE LOOKUP TO. MORE SPECIFICALLY, EACH OF MY SHEETS ARE A STORE NUMBER, 201, 202, 203, ETC., AND IN THE SUMMARY SHEET I HAVE THE STORE NUMBERS LISTED IN A COLUMN. IS THERE A FORMULA TO USE THE STORE # FROM THE CURRENT SHEET'S CELL REFERENCE THAT WOULD USE IT IN THE FORMULA AS THE TAB NAME? I HOPE I EXPLAINED THIS GOOD ENOUGH. IT WOULD SAVE ME A LOT OF TIME. ANY HELP IS APPRECIATED. EXAMPLE: IF CELL A1 CONTAINED THE NUMERICAL VALUE OF 201 AND THE TAB I WANT TO LOOKUP TO WAS SHEET 201, WHAT FORMULA WOULD LOOK AT CELL A1 AND PUT THE SHEET NAME OF 201 IN THE LOOKUP FORMULA? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
EXCEL - FORMULA TO CREATE A TAB REFERENCE
Have a look at the INDIRECT function -- Pecoflyer Cheers - *_Membership_is_free_* & allows file upload -faster and better answers ------------------------------------------------------------------------ Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=46385 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
EXCEL - FORMULA TO CREATE A TAB REFERENCE
Please get that caps lock key repaired so that you can stop SHOUTING.
-- David Biddulph Dan Wiese wrote: I WANT TO LOOKUP INFORMATION IN MULTIPLE SHEETS AND WOULD LIKE TO BE ABLE TO USE A FORMULA TO REFERENCE A CELL IN THE CURRENT SHEET WITH THE SPECIFIC SHEET NAME THAT I WANT TO DO THE LOOKUP TO. MORE SPECIFICALLY, EACH OF MY SHEETS ARE A STORE NUMBER, 201, 202, 203, ETC., AND IN THE SUMMARY SHEET I HAVE THE STORE NUMBERS LISTED IN A COLUMN. IS THERE A FORMULA TO USE THE STORE # FROM THE CURRENT SHEET'S CELL REFERENCE THAT WOULD USE IT IN THE FORMULA AS THE TAB NAME? I HOPE I EXPLAINED THIS GOOD ENOUGH. IT WOULD SAVE ME A LOT OF TIME. ANY HELP IS APPRECIATED. EXAMPLE: IF CELL A1 CONTAINED THE NUMERICAL VALUE OF 201 AND THE TAB I WANT TO LOOKUP TO WAS SHEET 201, WHAT FORMULA WOULD LOOK AT CELL A1 AND PUT THE SHEET NAME OF 201 IN THE LOOKUP FORMULA? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
EXCEL - FORMULA TO CREATE A TAB REFERENCE
Dan,
in future do not submit posts that are all in capitals (or SHOUTING) - it makes them difficult to read, and is considered rude. It also helps if you could describe how your data is laid out in your sheet(s), i.e. what columns you use for what data. You may be able to use VLOOKUP or an INDEX/MATCH combination, but you will probably have to use INDIRECT within these functions to define the lookup table, something like: INDIRECT("'"&A1&"'!A1:F100") assuming your tables occupy A1:F100 on each sheet. Hope this helps. Pete On Jan 4, 6:40*pm, Dan Wiese wrote: I WANT TO LOOKUP INFORMATION IN MULTIPLE SHEETS AND WOULD LIKE TO BE ABLE TO USE A FORMULA TO REFERENCE A CELL IN THE CURRENT SHEET WITH THE SPECIFIC SHEET NAME THAT I WANT TO DO THE LOOKUP TO. *MORE SPECIFICALLY, EACH OF MY SHEETS ARE A STORE NUMBER, 201, 202, 203, ETC., *AND IN THE SUMMARY SHEET I HAVE THE STORE NUMBERS LISTED IN A COLUMN. *IS THERE A FORMULA TO USE THE STORE # FROM THE CURRENT SHEET'S CELL REFERENCE THAT WOULD USE IT IN THE FORMULA AS THE TAB NAME? *I HOPE I EXPLAINED THIS GOOD ENOUGH. *IT WOULD SAVE ME A LOT OF TIME. *ANY HELP IS APPRECIATED. * * * * * * EXAMPLE: IF CELL A1 CONTAINED THE NUMERICAL VALUE OF 201 AND THE TAB I WANT TO LOOKUP TO WAS SHEET 201, WHAT FORMULA WOULD LOOK AT CELL A1 AND PUT THE SHEET NAME OF 201 IN THE LOOKUP FORMULA? * * * * * * * * * * * * |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using a cell in formula to create a reference | Excel Worksheet Functions | |||
Using a cell in formula to create a reference | Excel Worksheet Functions | |||
I want to be able to create a dynamic reference in excel, for exam | Excel Worksheet Functions | |||
create reference formula that looks through all sheets for matchin | Excel Worksheet Functions | |||
Using a formula to create named range reference | Excel Worksheet Functions |