| 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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using text to lookup different table arrays in vlookup.
Have a look at VLOOKUP in Help
Then come back for more info. We will need to know how the data is set out on the worksheets best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "stuart" wrote in message ... 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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using text to lookup different table arrays in vlookup.
I have checked Vlookup to no avail:
Workbook contains 13 different business segments. Segment 1 to Segment 13. Each Segment has standardised cost items. Vlookup(a4,segment1!b:e,3,0). My question is whether I can insert the table lookup (ie. 'segment 1') by having a reference in the summary page. Eg. if i had a list of all segment names in cells z1:z13, can i use something like vlookup(a4,z1&"!b:e",3,0)? Cheers "Bernard Liengme" wrote: Have a look at VLOOKUP in Help Then come back for more info. We will need to know how the data is set out on the worksheets best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "stuart" wrote in message ... 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. |
| Reply |
| 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 | |||
Linear Mode
