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?

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

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?