vlookup cased on dropdown

[rooster05]

i have a dropdown in A1 which is 2 companies, i have data for these companies on 2 separate worksheets. what i would like is, if A1 =company 1 i could have a vlookup for that sheet in tabs A4:D4, but if A1 = company 2 a vlookup to that sheet would be needed for the same range.

i have looked at videos and read examples but nothing seems to be clear, any help and advice would be greatly appreciated

 

[ORoxo]

i have a dropdown in A1 which is 2 companies, i have data for these companies on 2 separate worksheets. what i would like is, if A1 =company 1 i could have a vlookup for that sheet in tabs A4:D4, but if A1 = company 2 a vlookup to that sheet would be needed for the same range.

i have looked at videos and read examples but nothing seems to be clear, any help and advice would be greatly appreciated

=if(A1="ABC";vlookup(lookupvalue;Sheet1!A4:D4;0);vlookup(lookupvalue;Sheet2!A4:D4;0))

Substitute "ABC" by the name of the company you have on the dropdown and "lookupvalue" by the value you want to look up for on sheets 1 and 2. That should do the trick.

Cheers,
ORoxo

 

[rooster05]

Sorry for the delay, that worked a treat.
Thanks for the speedy reply and assistance