Hi guys,
Wondering if anyone can point me in the right direction please....
Problem:
I have item numbers listed in column "E"
these items are located @ "A1" dropdown menu Venue1 & Venue2
In column G I have the formula as =IF(A1="Venue1",VLOOKUP(E2,A10:B18,2,FALSE)),IF(A1="Venue2",VLOOKUP(E2,A1:B9,2,FALSE))
which is meant to check on the sales percentages as per each section.
I keep getting an error, the attached spreadsheet should narrate it better if my dribble has not lol,
What is it I'm not understanding or doing wrong within the formula or cannot even be done?
Using eXcel'16
Any help,
Much appreciated,
Chad
Bookmarks