Thread: Vlookup always gives me #NA
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SteveG
 
Posts: n/a
Default Vlookup always gives me #NA

True. VLOOKUP will not look to the left but given the example in the
OP, the value is to the right of the grpID. The other option would be
to use the ID field for the lookup if the ID's are unique to the grpIDs
which it appears they are in the sample data.

Steve


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

Reply With QuoteReply With Quote