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")
You have two tables, Table615 and Table6, where you would like to place the result?
Next, R1=Table615[Date] returns some array, within it you would like to place another array depends on condition. Afraid that doesn't work.
Perhaps you may share small sample file to illustrate the case?
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.