I'm trying to check the first four numbers found in column A and see if they are located anywhere in column O. I've tried VLOOKUP with LEFT but cannot seem to get the it to work. It always results in an #NA error. My goal is; if the first four numbers is not found anywhere in column O, I would like the result of the formula to display the numbers that were not found in column O. i.e. if column A has 1234 as the first four numbers and it is not found anywhere in column O, the result of the formula should display 1234.
This is the formula I've tried
[ =VLOOKUP(VALUE(LEFT(A2,4)),LEFT($O$2:$O$500,4),2,FALSE) ]
Thank you in advance for your assistance.
This is the formula I've tried
[ =VLOOKUP(VALUE(LEFT(A2,4)),LEFT($O$2:$O$500,4),2,FALSE) ]
Thank you in advance for your assistance.