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?

Hi,

You could have additional leading or trailing characters. Insert a blank
column adjacent to the data and try Len function and check the number of
characters it returns against the actual count of the characters. If len
returns more characters then try Trim and Clean and see if that works.
--
Regards,

OssieMac


"Belinda7237" wrote:

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?

Perfect, thanks - the len formula allowed me to see there was one extra
character!

"Belinda7237" wrote:

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?