VLOOKUP

[GARY]

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?

 

[Peo Sjoblom]

=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

 

[T. Valko]

whose contents exactly match those in Col B?

How literal do you mean exactly?

Exactly means Xx and XX do not match.