problem with if thens and vlookup

[RAMatgreenleaf]

i have a spreadhset which i have 3 macro buttons on them
for 3 diff brands

EPhenry
Tech
Imperial

when i put the macro button next to each brand it puts a value in p7 and then changes a drop down menu with sub products under the brand

the drop down is in g6

=IF(G6="","",IF(P7="EPHenry",VLOOKUP(G6,P28:Q43,2,0),IF(P7="Techo Block",VLOOKUP(G6,S28:T51,2,0),IF(P7="Imperial",VLOOKUP(V28:W36,2,0)))))

this is what i have for a cell C9
when you select the brand it puts the name in P7
when you select the drop down product in G6 it then uses vlookup to find the price that does with that product

now i had it working all fine with 2 brands
as soon as i threw the 3rd in there i am having a problem
is there a limit to the amount you can have?

 

[texasalynn]

looks like on the third one you left off the 1st part of formula
=IF(G6="","",IF(P7="EPHenry",VLOOKUP(G6,P28:Q43,2,0),IF(P7="Techo Block",VLOOKUP(G6,S28:T51,2,0),IF(P7="Imperial",VLOOKUP(G6,V28:W36,2,0)))))

 

[onlyadrafter]

Hello,

Your last VLOOKUP hag (G6, missing

 

[RAMatgreenleaf]

THANK YOU

ive been trying to get it to work since fri

something so mall its easy to overlook but so important to have

thank you all