I'm trying to identify the first 3 digits of the cells in Column G with the list of 3-digit numbers (array) in Column N. I've tried the following formula but it only returns "No" results in every cell:
=IF(ISNUMBER(MATCH(LEFT(G2,3),N2:N72,0)),"Yes","No")
EX.
COL G COL N COL with EXPECTED RESULT
123456789 987 No
987654321 247 Yes
456789123 248 No
321654987 249 Yes
250
321
I've also tried creating a table for Column N, but the result was the same. I also tried to format the data in Column G and N as both numbers, text and general. Same results. Getting frustrated. Can you assist?
Thanks so much!
=IF(ISNUMBER(MATCH(LEFT(G2,3),N2:N72,0)),"Yes","No")
EX.
COL G COL N COL with EXPECTED RESULT
123456789 987 No
987654321 247 Yes
456789123 248 No
321654987 249 Yes
250
321
I've also tried creating a table for Column N, but the result was the same. I also tried to format the data in Column G and N as both numbers, text and general. Same results. Getting frustrated. Can you assist?
Thanks so much!