Thread: How do I combine a VLOOKUP formula and a NETWORKDAYS formula?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tracy Tracy is offline
external usenet poster
  
Posts: 70
Default How do I combine a VLOOKUP formula and a NETWORKDAYS formula?
If cell G3 equals "Defer to Network" then I want cell J3 to equal "N/A". If
cell G3 equals "MTF Accept" then I want cell J3 to use a NETWORKDAYS formula
to calculate the difference in days. How do I combine the two formulas?
Thanks.
Reply With QuoteReply With Quote