I am trying to match two worksheets that have a common element and return the
value in another cell. I have used this same formula many times and it
always works, however with this set of data it is saying my data doesnt match.

=IF(ISNA(MATCH(D3,'Drop Monday PWM Sheet here'!F:F,0)),"",INDEX('Drop Monday
PWM Sheet here'!B:B,MATCH(D3,'Drop Monday PWM Sheet here'!F:F,0),1))

I am thinking it has something to do with the formatting of the F column in
each sheet as I pulled this data down from a delimited file. Here is an
example:

00075000102809100000000273

I have formatting this column as text, as general etc but nothing works?

Any ideas?