Forum Discussion
Solved
Use If formula to subtract different numbers according to a specific word
I am trying to build a tracker for award timelines but we have different awards with different time requirements for submission. For a service award it needs to be to HR 15 days prior to today but if...
Create a lookup table, for example on another sheet:
You can then use VLOOKUP:
The formula in D3 is
=C3-VLOOKUP(B3,Sheet2!$A$2:$B$3,2,FALSE)
Create a lookup table, for example on another sheet:
You can then use VLOOKUP:
The formula in D3 is
=C3-VLOOKUP(B3,Sheet2!$A$2:$B$3,2,FALSE)
HansVogelaar
Thanks for the help and advice. It has been awhile since I used VLOOKUP and forgot the possibilities with that function. Your help was able to get the excel to work as desired with no issues. Thanks for the quick reply!