VLOOKUP
 

In my Excel 2007 worksheet, Col A has 2500 cells and Col B has 1
million cells.

How should the VLOOKUP formula be written to find the cells in Col A
whose contents exactly match those in Col B?

VLOOKUP
 

=COUNTIF(B:B,A1)0

copy down will return TRUE for a match, you might want to use the formula in
format conditional formatting to highlight the cells in A1 that matches

For more info see

http://www.cpearson.com/excel/Duplicates.aspx


--

Regards,

Peo Sjoblom




"GARY" wrote in message
ps.com...
In my Excel 2007 worksheet, Col A has 2500 cells and Col B has 1
million cells.

How should the VLOOKUP formula be written to find the cells in Col A
whose contents exactly match those in Col B?

VLOOKUP
 

whose contents exactly match those in Col B?

How literal do you mean exactly?

Exactly means Xx and XX do not match.

--
Biff
Microsoft Excel MVP


"GARY" wrote in message
ps.com...
In my Excel 2007 worksheet, Col A has 2500 cells and Col B has 1
million cells.

How should the VLOOKUP formula be written to find the cells in Col A
whose contents exactly match those in Col B?