vlookup - matches not made


Posted by jeff on April 10, 2001 8:22 AM

Vlookup is not displaying all appropriate matches - only some of them. I have tried adjusting the cell formatting to be consistent using "general." I've never had this problem before.

Any ideas?



Posted by Mark W. on April 10, 2001 8:27 AM

By chance, have you...

...omitted the 4th (optional) argument to the VLOOKUP
function? Or, have you used 1 or TRUE as the 4th
argument?