Compare two columns, only return the differences.

[jschomisch]

Columns F and G are pulling project numbers from two different programs. Column G has the project number and the title, while column F only has the project number. We are not allowed to use macros on our work computers, I want column A to have a list of project numbers that are in F but not in G. My difficulty is the title in with the project numbers in G (and they aren't always at the beginning), so I can't get MATCH or INDEX to work like I want them too.

 

[jschomisch]

Using ifna won't make any difference, as the formula is returning #calc, not #n/a.
The formula in post#8 should prevent the #calc error.

I see the difference between the two formulas now, and it works as expected. Thank you very much for your help!

 

[Fluff]

You're welcome & thanks for the feedback.