Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
References to worksheets in formulae
Hi, I've got a vlookup and the range I want looked at can be one of four tables, each of these is on a different sheet. Currently I either use an if: if(V2=1, vlookup..., if(V2=2, vlookup... and so on or I filter the data on the value that affects the range I want looked at and only type then copy the correct formula in each case. I was wondering, however, if there is any way to include the value in the lookup table array. The reference to different worksheets is "'-Name of steet'!-" Could I replace this somehow with a cell reference so that if I named the sheets the same as the values that affect the result this calculates automatically. Or am I being daft and should carry on as I am. Any help/guidance would be appreciated Andy -- andyiain ------------------------------------------------------------------------ andyiain's Profile: http://www.excelforum.com/member.php...fo&userid=8335 View this thread: http://www.excelforum.com/showthread...hreadid=560170 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to auto-increment data source cell references when copying cha | Charts and Charting in Excel | |||
How do you copy and rename linked worksheets? | Excel Discussion (Misc queries) | |||
Changing cell references in formulas to names and back again. | Excel Discussion (Misc queries) | |||
Excel needs to have the ability to insert "SUB" worksheets | Excel Worksheet Functions | |||
Replicating Formulas with Various Worksheet References | Excel Worksheet Functions |