Put this in C1 & copy down

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

"biz" wrote:

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