Hi,

I am excel 2003 user

I have multiple criteria to locate information e.g. Price history within my database.
(Criteria: e.g. Industry, Period, credit rating)

One of the criteria is sometimes blank and if so, I would like for excel to ignore this criteria altogether and locate the information based on the remaining information, instead of trying to match the blank cell to the result.

The functions are Min/Max/ Average price info within database.

This is currently the formula that I have managed to build, which will include the blank cell to locate the price info.

=MIN(IF((Database!$C$2:$C$14>=$B$4)*(Database!$C$2:$C$14<='Output - Summary'!$C$4)*(Database!$B$2:$B$14='Output - Summary'!$B$5),Database!P2:$P$14,""))

Your help/advice will be much appreciated!

Cheers,
Nat