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