|Hi, really hope you can help me with a tricky (I assume) VLOOKUP problem in Excel 2010,|
I have a spreadsheet provided by a colleague which lists asset information over a number of similar sheets. Each sheet is a room and the sheet lists up to 60 assets along with associated asset data. Each row is a unique entity/asset across the whole spreadsheet. On all these sheets the unique identifier is in Row A and I need to return the value in row W (asset life).
I have added a MySheets sheet which lists the sheet names.
I have added a master sheet which lists all entities (taken from another asset list) but has older data (which I need to update). I've added a blank column G next to the existing data that I want to compare.
For each of the 7000 rows in the Master sheet I need to search for the same unique item in column B throughout all the other sheets (column A). I then need to return the value in column W from whatever sheet it is on into column G of the correct asset in the Master Sheeet.
Sorry for the long winded explanation, hopefully it makes some sort of sense. I've tried various versions of VLOOKUP and INDEX (found after google searches) but can't work out the correct syntax. With luck one of you much cleverer individuals may be kind enough to assist.
Many thanks in advance.
message edited by GaryG