Hello,
I need a formula that can return the valve based on two conditions. The first condition is a date array and the second condition is a numerical valve array. For example, on my attached spreadsheet, my formual needs to find the valve that is associated with cell E2 (2) and E3 (7/31/14). It should return 3 (in cell C7).
Thank you,
Work Orders.xlsx
Bookmarks