INVALID DATA TYPE AFTER CONVERTING TO A STRING

lgonzales

I am trying to create a column formula to check if a value exists in another sheet. The value in both sheets consist of numbers and letters, so I assumed I need to convert both columns to a string. Even after referencing the new helper string columns, I am still getting an invalid value. Anyone know how to resolve this? @Paul Newcome - you've been my hero before, you wizard. Any advice?

Paul Newcome

Are you able to provide some screenshots for context?

lgonzales

@Paul Newcome

Screenshot 2024-05-06 152612.png

Screenshot 2024-05-06 152647.png

Screenshot 2024-05-06 152719.png

Screenshot 2024-05-06 152746.png

Paul Newcome

I'm not sure what exactly I am looking at in your screenshots. Are you able to describe each one? How many different sheets are there?

One thing I do notice is your use of the MATCH function. The MATCH function outputs a number. So if the string you are searching for is in the 15th cell within the range you are searching in, your formula becomes

=IF(15, false, true)

What exactly are you wanting to accomplish?

lgonzales

I am trying to return a true if the value is present in another sheet

Paul Newcome

In that case, I would use an IF/COUNTIFS.

=IF(COUNTIFS({Other Sheet String Column}, @cell = [String Column]@row)> 0, 1)