| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using text to lookup different table arrays in vlookup.
At work I have a number of workbooks that contain a summary page and a number
of other pages all in the same format. Is there a formula which can automate the table array a lookup function will lookup in the summary page? At present I have to copy the formula down then change the table_array manually. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLOOKUP not working due different formats in lookup data & table? | Excel Discussion (Misc queries) | |||
| LOOKUP across multiple arrays | Excel Discussion (Misc queries) | |||
| vLookup with multiple lookup value in table array | Excel Worksheet Functions | |||
| IF, VLOOKUP & LOOKUP TABLE ON OTHER SHEET | Excel Discussion (Misc queries) | |||
| VLOOKUP CONDITION TO RETURN BLANK CELL WHERE LOOKUP VALUE IS NOT IN TABLE ARRAY | Excel Worksheet Functions | |||
Threaded Mode
