SPXHT
asked on
Invoice date formula
Need the highlighted yellow section updated with the "date" in the Raw Data tab as to when the MS# will be invoiced.
Please let me know if you have any questions or concerns.
Pete
27835685-Test-File.xlsx
Please let me know if you have any questions or concerns.
Pete
27835685-Test-File.xlsx
Berry could you explain the 9.99E+307? what's up with that value?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
That works!
Thanks,
Pete
Thanks,
Pete
=IFERROR(LOOKUP(9.99E+307,
see attached
regards, barry
dates.xlsx