INDEX & MATCH

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top