vlookup

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum Values from different column 1
Need VLOOKUP to Work Two Ways 0
Dynamic col_index_num in VLOOKUP? 5
Excel Trying to do a vlookup with a nested right function on the array 3
Yes or blank, depending if value equals or exceeds value found inVLookup table. 4
Excel IF statement with vlookup 2
VLOOKUP results in problems in comparing 3
Duplicate value causes VLOOKUP issue... 6

Back
Top