Using MAX function with nested AND statement within an IF statement
Posted on 2011-04-21
I am trying to write a formula in my Excel spreadsheet to perfrom the following:
For a value in column A on Sheet 1, I am trying to look up the corresponding value in a named range (column A on sheet 2) named 'NAME' and return the highest value from named range (column D on sheet 2) named 'DATE' where the parameter in named range (column B on sheet 2) named 'TYPE' is equal to ACTIVE.
Here is what I have so far:
This returns the highest value fromt he DATE range regardless of type.
The change I tried to make is as follows:
This returns a value of zero rather than the highest value int he DATE range where NAME = A2 and TYPE = ACTIVE.
Can someone help me with what I am doing wrong?