Min if function doesn't work for earliest date lookup

[alexcrofut]

Hello,
I am having issues with a min if formula
even though i enter it as an array (ctrl +shift+enter), it only returns a zero.

the formula is supposed to return the earliest date from Raw data if the name of the company matches the one from the data validation ('Company lookup'!D3)
Dates are in column D and company name in column M
I checked, the dates are all formatted as dates

=MIN(IF(RAW!$M:$M,'Company lookup'!D3,RAW!$D:$D))

does anyone know what I am doing wrong?

[Jonmo1]

Blanks will be counted as Zero
Zero is a perfectly valid numerical value for the MIN function to return.

You have to add a criteria for <>""


I also strongly recommend NOT using entire column references like M:M
Specify row #s explicitly like M1:M1000

Try
=MIN(IF(RAW!$M:$M='Company lookup'!D3,IF(RAW!$D:$D<>"",RAW!$D:$D)))

[Fotis1991]

Hi

Formula is ok. Are you sure that 'Company lookup'!D3 matces in RAW!$M:$M column?

If yes, then we have to see a small example workbook with your data.

[sktneer]

I think your formula should be like this.....

Please Login or Register  to view this content.

Confirmed with Ctrl+Shift+Enter