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?