INDEX & MATCH
 

Hi

I want to find the earliest date that an item was issued. The following
works well

=IF(ISBLANK(B7),"",IF(ISNUMBER(MATCH(B7,$D$21:$D$4 4)),INDEX($B$21:$B$44,MATCH(B7,$D$21:$D$44,-1))))

However, when I try to increase the range to future proof the formula I get
an error.
=IF(ISBLANK(B7),"",IF(ISNUMBER(MATCH(B7,$D$21:$D$5 4)),INDEX($B$21:$B$54,MATCH(B7,$D$21:$D$54,-1))))

the formula returns FALSE
Really I'd like to increase it to 100 or so to be sure

TIA
Peter

INDEX & MATCH
 

Hi,

There's nothing wrong with your formila and changing 44 to 100 will extend
the range and not create an error.

If it returns FALSE that means it isn't finding a match in Col D. If you
think there is a match then check your data formats.

Mike

"Billy Liddel" wrote:

Hi

I want to find the earliest date that an item was issued. The following
works well

=IF(ISBLANK(B7),"",IF(ISNUMBER(MATCH(B7,$D$21:$D$4 4)),INDEX($B$21:$B$44,MATCH(B7,$D$21:$D$44,-1))))

However, when I try to increase the range to future proof the formula I get
an error.
=IF(ISBLANK(B7),"",IF(ISNUMBER(MATCH(B7,$D$21:$D$5 4)),INDEX($B$21:$B$54,MATCH(B7,$D$21:$D$54,-1))))

the formula returns FALSE
Really I'd like to increase it to 100 or so to be sure

TIA
Peter