Thread: VLookup Error in Part of a Named Range
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dallas64
 
Posts: n/a
Default VLookup Error in Part of a Named Range
Perfect! Thanks!!!

"Biff" wrote:

OK....

Just change the last argument in the lookup function to FALSE or 0 for
short:

=IF(N460="","",VLOOKUP(N460,IDNumbers,2,0))

Biff


Reply With QuoteReply With Quote