hello i am trying to formula to identify if a value is in both columns, the entries are in text format for example below
so in the below i would have a column C where i did a lookup of the value in column B compared to column A and it would return the value in column A, does that make sense? right now if i did a normal lookup it would come back #NA because column A does not match column B exactly
so in the below i would have a column C where i did a lookup of the value in column B compared to column A and it would return the value in column A, does that make sense? right now if i did a normal lookup it would come back #NA because column A does not match column B exactly
Column A | Column B |
John Doe Inc | John Doe |