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

how does it fail you?

"Excluxe" wrote:

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

#N/A

"bj" wrote:

how does it fail you?

"Excluxe" wrote:

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

#NA
indicates no match
in a blank cell try
= AM154 = c276
when C276 has a value which looks like AM154
if the answer is false, you may have a space or other non-print character in
one of the two.
=len(AM154)-Len(C276) will help you determine which.

"Excluxe" wrote:

#N/A

"bj" wrote:

how does it fail you?

"Excluxe" wrote:

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

Ok so it said True. So what then do I do to fix this problem. For the
formula I posted with my question I have had spaces in the matching cells and
it has worked fine. Is there something else confusing it. Here is a sample
of my list. This is what all my cells like if you change around numerics.
48x60x60 23000 CFM


"bj" wrote:

#NA
indicates no match
in a blank cell try
= AM154 = c276
when C276 has a value which looks like AM154
if the answer is false, you may have a space or other non-print character in
one of the two.
=len(AM154)-Len(C276) will help you determine which.

"Excluxe" wrote:

#N/A

"bj" wrote:

how does it fail you?

"Excluxe" wrote:

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

for it to say true
it there is evidently a different non-printing character in the two cells
try
=substitute(AM154," ","")
and
=substitute(C276," ","")
in one of them, there will probably be what appears to be a space left.

use
=code(this apparent space) to find out what it is


you can then use find replace to change all of them to spaces


"Excluxe" wrote:

Ok so it said True. So what then do I do to fix this problem. For the
formula I posted with my question I have had spaces in the matching cells and
it has worked fine. Is there something else confusing it. Here is a sample
of my list. This is what all my cells like if you change around numerics.
48x60x60 23000 CFM


"bj" wrote:

#NA
indicates no match
in a blank cell try
= AM154 = c276
when C276 has a value which looks like AM154
if the answer is false, you may have a space or other non-print character in
one of the two.
=len(AM154)-Len(C276) will help you determine which.

"Excluxe" wrote:

#N/A

"bj" wrote:

how does it fail you?

"Excluxe" wrote:

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