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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Identifying non-returning formula (blank Cell) 9
Array Average - Multiple Conditions? 3
VBA Custom function for lookup 9
Use vlookup within offset? 4
With F1 value, look at A, if match or partial match return B 5
Index Match Concatenate 8
MATCH search with text and numbers 1
Combine HLOOKUP and MATCH 2

Back
Top