IF & VLOOKUP together

[Ballymack]

Hi, I have a scenario where I have 3 sheets/tabs with 3 different sets of data in them. So lets call the tabs 1stWash, 2ndWash, 3rdWash.
In another tab lets call it Results I have to return the Postcode from the 1stWash (say column 47 if a cell value = 1) If however the cell value = 2 then I need to return the Postcode from 2ndWash in Column 8. Like wise if the cell value = 3 then return the Postcode from 3rdWash in Column 17.

So basically IF a cell value = 1,2 or 3 then VLOOKUP the Postcode in the respective sheet and return that postcode to the cell.

Column A on all sheets will contain the lookup reference.

Regards
KC

 

[gaz_chops]

Something like

=if(cell value = 1,1st vlookup,if(cell value = 2,2nd vlookup,3rdvlookup))

 

[Ballymack]

Spot on gaz_chops. Cheers