ExcelBanter - vlookup

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

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

- - vlookup (https://www.excelbanter.com/excel-worksheet-functions/155329-vlookup.html)

zolabus

vlookup

Hi
i have two column with similar but not equal values
haw can i use vlookup to see wich elements of the B column are not in the A
column?
Thanks a lot

Max

vlookup

One way ..
Assuming data in row2 down
Place in C2: =ISNUMBER(MATCH(B2,A:A,0))
Copy down to the last row of data in col B
Then do an autofilter on col C, filter out FALSE
--
Max
Singapore
http://savefile.codm/projects/236895
xdemechanik
---
"zolabus" wrote:
Hi
i have two column with similar but not equal values
haw can i use vlookup to see wich elements of the B column are not in the A
column?
Thanks a lot

All times are GMT +1. The time now is 07:28 AM.