Vlookup formula - Excel Version 2002

B

biz

Can someone provide me with a vlookup formula to compare 2 columns ( Col A
versus Col B) & return the matched values in Column C?
 
D

Duke Carey

Put this in C1 & copy down

=IF(ISNA(VLOOKUP(B1,$A$1:$A$1000,1,0)),"",VLOOKUP(B1,$A$1:$A$1000,1,0))
 
Top