G
Guest
So my trusty formula is failing me. This my formula
=VLOOKUP(C276,AM133:AO154,MATCH(L276,AM132:AO132,0),0) This is my a small
portion of my data
AM AO
Sound Trap
12x18x36 2000 CFM 288
24x18x36 9000 CFM 325
This continues til AM 154 giving a list of sizes and prices. C276 is a drop
down list of the sizes and L276 is a drop list of the name. Which is
soundtrap and then a blank. I have used this formula multiple times and this
is the first time it has failed on me and I can't figure out why. Is it
because the names are to extensive . I know the formulas are picky about
correct order but how do you order this
12x18x36 2000 CFM
24x18x36 9000 CFM
24x24x36 9000 CFM
24x30x36 9000 CFM
24x36x36 9000 CFM
24x48x36 9000 CFM
36x18x36 6300 CFM
36x36x36 6300 CFM
36x48x36 6300 CFM
36x60x36 6300 CFM
48x48x36 6300 CFM
24x24x60 6000 CFM
24x30x60 7000 CFM
24x36x60 8000 CFM
24x48x60 11000 CFM
36x18x60 6300 CFM
36x36x60 12000 CFM
36x48x60 17000 CFM
36x60x60 20000 CFM
48x48x60 23000 CFM
48x60x60 23000 CFM
I have tried by size and by CFM but it still doesn't work.
Thanks for the help
=VLOOKUP(C276,AM133:AO154,MATCH(L276,AM132:AO132,0),0) This is my a small
portion of my data
AM AO
Sound Trap
12x18x36 2000 CFM 288
24x18x36 9000 CFM 325
This continues til AM 154 giving a list of sizes and prices. C276 is a drop
down list of the sizes and L276 is a drop list of the name. Which is
soundtrap and then a blank. I have used this formula multiple times and this
is the first time it has failed on me and I can't figure out why. Is it
because the names are to extensive . I know the formulas are picky about
correct order but how do you order this
12x18x36 2000 CFM
24x18x36 9000 CFM
24x24x36 9000 CFM
24x30x36 9000 CFM
24x36x36 9000 CFM
24x48x36 9000 CFM
36x18x36 6300 CFM
36x36x36 6300 CFM
36x48x36 6300 CFM
36x60x36 6300 CFM
48x48x36 6300 CFM
24x24x60 6000 CFM
24x30x60 7000 CFM
24x36x60 8000 CFM
24x48x60 11000 CFM
36x18x60 6300 CFM
36x36x60 12000 CFM
36x48x60 17000 CFM
36x60x60 20000 CFM
48x48x60 23000 CFM
48x60x60 23000 CFM
I have tried by size and by CFM but it still doesn't work.
Thanks for the help