Michelle,

When I reproduced your information as stated in your last post, I got
the N/A error as well. I noticed in your formula that you are using
the condition of the VLOOKUP as "False". What I did to correct it was
change the word "False" to all caps FALSE and bingo, it worked. Give
it a try.


Cheers,

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=491153