Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
indirect?
I have 4 workbooks, named fish,meat,fruit and veg. Each of the workbooks is
populated with multiple worksheets, each worksheet is unique for one item ( as the list below). apple pear lamb chicken carrot potato I have a master workbook that lists all of the items across all of the workbooks, in column A. I need a formula in column B that will look up each of the items in the relevant workbook and report what it finds in cell H2 in the workbook. I can do the vlookup ok BUT I don't want to have to change the formula for each individual item. I'm sure and indirect is involved but I can't crack it. any ideas please? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
indirect?
Indirect is not working with closed workbooks
-- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "mepetey" wrote in message ... I have 4 workbooks, named fish,meat,fruit and veg. Each of the workbooks is populated with multiple worksheets, each worksheet is unique for one item ( as the list below). apple pear lamb chicken carrot potato I have a master workbook that lists all of the items across all of the workbooks, in column A. I need a formula in column B that will look up each of the items in the relevant workbook and report what it finds in cell H2 in the workbook. I can do the vlookup ok BUT I don't want to have to change the formula for each individual item. I'm sure and indirect is involved but I can't crack it. any ideas please? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Allow EXCEL INDIRECT(ADDRESS()) and INDIRECT(RANGE()) functions | Excel Worksheet Functions | |||
INDEX("a"&COLUMNS(INDIRECT(A1):INDIRECT(A2)):A30,4) | Excel Discussion (Misc queries) | |||
Please help w/ INDIRECT | Excel Worksheet Functions | |||
#REF using =INDIRECT... | Excel Worksheet Functions | |||
Need help with Indirect | Excel Discussion (Misc queries) |