Need Vlookup help
- Thread starter d380013
- Start date
Smallman
Excel Ninja
Hi d380013
OK lets not let the fact that there is no sheet 24 or 25 so using the cell references will be difficult. Firstly I don't like the use of indirect formula. I think you can set your workbook up in such a way as to have a consolidation sheet and 'tap' this sheet for the information you require. Then you would flick from a vlookup to a sumifs formula. You do not have a big file as it currently stands and this would allow you to change your setup slightly by storing all the individual sheets in one Consolidation sheet which using a column to differentiate each block of data.
OK here goes. Put this formula in cell B9 of the Price volume tab
=VLOOKUP($A9,INDIRECT("'"&B$8&"'!B2:R302"),16,0)
Drag it across and down when you get to Col J and L you might want to change the header to read 244 and 245 respectively.
Tested and it seems to work OK.
Take care
Smallman
OK lets not let the fact that there is no sheet 24 or 25 so using the cell references will be difficult. Firstly I don't like the use of indirect formula. I think you can set your workbook up in such a way as to have a consolidation sheet and 'tap' this sheet for the information you require. Then you would flick from a vlookup to a sumifs formula. You do not have a big file as it currently stands and this would allow you to change your setup slightly by storing all the individual sheets in one Consolidation sheet which using a column to differentiate each block of data.
OK here goes. Put this formula in cell B9 of the Price volume tab
=VLOOKUP($A9,INDIRECT("'"&B$8&"'!B2:R302"),16,0)
Drag it across and down when you get to Col J and L you might want to change the header to read 244 and 245 respectively.
Tested and it seems to work OK.
Take care
Smallman