IF with VLOOKUP

[James Swallow]

Hi.

Noobie to the forum here. I'm having issues with combining IF with VLOOKUP. My formula is as follows:

=IF(VLOOKUP(I2,J:J,1,FALSE)=I2,"OK",I2)

The True section of the IF statement returns "OK" as prescribed, however, the False section returns #N/A instead of the contents of I2. I'm then using the adjacent collumn with an ISNA function to get the result I wanted in the first place:

=IF(ISNA(K2)=TRUE,I2,"")

This seems a convoluted approach and I'd like to see what I'm doing wrong rather than use this workaround. I'm very much self taught when it comes to Excel and any help would be greatly apprreciated.

Regards all,

James

[Glenn Kennedy]

Try this:

=IF(ISNA(VLOOKUP(I2,J:J,1,FALSE)),I2,"OK")

[Jonmo1]

Try

=IF(ISNA(MATCH(I2,J:J,0)),I2,"OK")

Or without the need to trap errors

=IF(COUNTIF(J:J,I2),"OK",I2)

[James Swallow]

Thanks both. Glenn's answer worked. Kind of obvious when you think about it but it had me stumped!

Really grateful. Have a good day

[Glenn Kennedy]

Nothing's obvious - if you can't see it!! Glad to have helped! If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.

[James Swallow]

All done ; )