hi.
yes, that is the literal text.
- "C3 x 4.1"

I've tried using the Match() function, with the match_type = 0, but it still
doesnt work. for cells with "10 x 2 x .125" it will find "10 x 2" and return
the value corresponding to that one.

"T. Valko" wrote:

C3 x 4.1

Is that the literal TEXT string C3 x 4.1 or does that mean cell C3 times
4.1?

If you're using the LOOKUP( ) function then the lookup_vector *must* be
sorted in ascending order otherwise there's no telling what result you may
get.

You can probably use the VLOOKUP( ) and set the range_lookup argument to 0
or FALSE to find exact matches only.

--
Biff
Microsoft Excel MVP


"Derrick" wrote in message
...
Why won't Lookup recognize C3 x 4.1 when the cell im looking it up in
has...
C3 x 4.1 exactly?
also in that column are 2 x 4, 2 x 2 x .125, and many more, but Lookup()
can
'lookup' these cells.

can anyone offer an explanation? or a method of fixing this?

thanks