VLOOKUP Multiple Worksheets

[winklar]

Hi,

Im in need of some help with regards to the VLOOKUP function. I have 4 spreadhsheets in all, the front main sheet plus 3 with different informatioin on. In the main sheet i want to collate all the data togther automatically rather than cut and paste becuase the data is ongoing and updating from other workbooks.

All 3 sheets have a one main column (lets say "A") then 5 or 6 columns after wards. I want the number in column "A" in the main sheet to match the number in the other 3 sheets then pull the information from the other 5 or 6 columns into the main sheet. So that if i changed the number in the main sheet column "A" to a different number it would change the other columns automatically.

Basically, if its not in sheet 1 then look in sheet 2, if not in 2 then look in 3.

Any help would be much appreciated.

Thanks

Wayne

[NBVC]

Try something like:

Please Login or Register  to view this content.

replace sheet names as appropriate and actual references or column ranges...

you can copy the formula down and across to extract relevant data.

[winklar]

That has worked a treat, however my sheet now takes for ever to update, im guessing that is just to do with the amount of data i hae.

Thanks alot.