karatelovr Wrote:
::
I used the above formula (FWIW I have to use semicolons instead of
commas) but the results are all \"DISTY\". :( Also, what is the
zero for in the VLOOKUP formula?::

I am guessing the data in your "DISTRIBUTOR" list do NOT really match
the data in your ALL NAMES list, therefore all matches fail. Verify
spelling, spaces and punctuation.

The zero in the formula is the same as FALSE (btw, 1=TRUE) and forces
the lookup to find an exact match or return the #N/A error. Bernie
used the same philosophy in his MATCH formula. Both should find
matches and return the desired results.


Good Luck.

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=469252