ExcelBanter - Vlookup formula - Excel Version 2002

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Vlookup formula - Excel Version 2002 (https://www.excelbanter.com/excel-worksheet-functions/47268-vlookup-formula-excel-version-2002-a.html)

biz

Vlookup formula - Excel Version 2002

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

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))

"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

All times are GMT +1. The time now is 12:01 AM.