Return what is missing

[DEllis]

I know I am over thinking this and that I have done this before but I cannot for the life of me figure it out today.

If I have a number in column A and I want to know if it is not in column F, how do I do the Vlookup to make it return to me the number from A that is missing from column F.

Help please.

Thank you,
DELlis

 

[Jonmo1]

Not sure I follow...but I think...

=ISNA(MATCH(A1,F:F,0))

This will give TRUE if A1 is NOT in column F, FALSE if A1 IS in column F.

 

[DEllis]

Jon, thank you for the quick response; however, it shows true for all of them and I know this is not correct as column A has more numbers in it then Column F.

Any other suggestions?

 

[Jonmo1]

Sounds like you have "Numbers Stored As Text", not real numbers...

Copy a BLANK cell.
Highlight column A
Right Click - PasteSpecial - Values - Add - OK

Repeat for Column F

 

[DEllis]

Did that and still get all trues. I truly must be doing something totally wrong.