Thread: Nested Vlookups
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bondi
 
Posts: n/a
Default Nested Vlookups
Hi,

=IF(ISNA(VLOOKUP(A1,Ref to Current employees
Array,24,FALSE)),VLOOKUP(A1,Ref to Terminated Employees
Array,24,FALSE),VLOOKUP(A1,Ref to Current employees Array,24,FALSE))

Regards,
Bondi

Reply With QuoteReply With Quote