Forum Discussion
Solved
Combining IF statement
Good day all, I am trying to combine two IF statements but cant get it to work. It needs to find the date and the allocated values for that date and only then follow the calculation formula. 1. =...
Here is a version that will work in Excel 2013:
=IFERROR(VLOOKUP($B$1, Table6, 3, FALSE)+(A3-VLOOKUP($B$1, Table6, 2, FALSE))*VLOOKUP($B$1, Table6, 4, FALSE), "Date Not Found")
SergeiBaklan Hi Sergei, please see the sample attached.
A3 and A4 contain #REF! because they refer to another workbook...
HansVogelaar Sorry, I forgot to remove the link.
If you have Microsoft 365 or Office 2021, the attached version should work.
- I have Office 2013:(