INDEX & MATCH

[Billy Liddel]

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$44)),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$54)),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

 

[Mike H]

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