RAMatgreenleaf
Board Regular
- Joined
- Sep 23, 2005
- Messages
- 84
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?
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?