App Match Error 2042

[bobkap]

I have the following code in my macro:
itemnocol = Application.Match("Item#", Worksheets("Prices").Range("1:1"), 0)
banana = Application.Match("Dist Price", Worksheets("Prices").Range("1:1"), 0)

I get the correct answer for "itemnocol", but using the exact same wording, I get an "Error 2042" for "banana". I've stared at this for a very long time and I just cannot see what I am not getting the correct response for banana.

This is what makes up my top row (1:1) -

Item#

Description

UOM

Case Pack

Dist Price

MSRP

<tbody>
</tbody>

 

[steve the fish]

It means 'Dist Price' is not in row 1 of the 'Prices' worksheet. You probably have a trailing space or something in the cell.

 

[bobkap]

MEGA thanks! You nailed it!!!