Vlookup function to compare Coumn2 values with Column1 and Column2 shows not present value

Column1 Column2 Not Present
A X
B Y
C A
D G
E R
F S
G T

Please compare Coumn2 values with Column1 and populate the non-present column2's values in column named 'Non present'.Kindly help.

I'm new to complex functions in excel 2007. Could someone let me know how to achieve this please?

Thanks alot!

So if the value from column 2(B) does not exist in column 1(A), then show "Not Present" ?

Try

=IF(ISNA(MATCH(B1,A$1:A$100,0)),"Not Present")

It's giving "Not present" to me, for all the coumn2's values. The following I've tried

=IF(ISNA(MATCH(H17,G17:G23,0)),"Not Present")

yes sktneer! Thanks alot, I apply on my complex data & give my feedback here soon!

Sktneer, I'm applying this formula on a table. The content I've mentioned here is formatted as table already. So for the arrays, it needs to coulmn names.In that case,how would I achieve please? Thanks a lot for your help!

You need to lock the Range in column G with $

Originally Posted by nnav

It's giving "Not present" to me, for all the coumn2's values. The following I've tried

=IF(ISNA(MATCH(H17,G$17:G$23,0)),"Not Present")

$