Which Vlookup to use from a cell

**JonesZoid** · 10-06-2009, 05:16 PM

Hi All,

I have a cell (A6 for instance) that contains 2 products - what i would like is for cell A2 to look at A6 and run the necessary vlookup.

Example.

If cell A6 showed "Prod A" - Cell A2 would vlookup from the "Prod A Sheet"
If cell A6 showed "Prod B" - Cell A2 would vlookup from the "Prod B Sheet"

Hope this is possible - as it will save a hell of a lot of time.....

Regards..

JonesZoid

**zbor** · 10-06-2009, 05:31 PM

SOmething like =IF(A6="Prod A";VLOOKUP(A2;....);IF(A6="Prod B";VLOOKUP(...);nO SUCH PROD")?

**JonesZoid** · 10-06-2009, 05:35 PM

I'll give it ago - and report back later....Thankyou

**stanleydgromjr** · 10-06-2009, 05:37 PM

JonesZoid,

You will have to fill in the correct VLOOKUP formulae for the following.

Try:
=IF(A6="Prod A",VLOOKUP('Prod A Sheet'……),IF(A6="Prod B",VLOOKUP('Prod B Sheet'….),"")