Andreamary
asked on
Expanding index-match formula to search for first non-blank cell in column
I have an index-match formula that I need to change so that it goes to the first non-blank cell in the column and returns the result. Currently, the formula does not proceed beyond its first match, therefore sometimes returning "n/a" when, in fact, there is a value. I've attached a sample file demonstrating this. The first worksheet contains the book data, the second worksheet contains the results I'm getting using the formula below, and the third worksheet shows the results I want.
=IFERROR(INDEX(Book_Data!$ D$2:$D$17, MATCH(A2,B ook_Data!$ C$2:$C$17, 0)),"n/a")
Thanks,
Andrea
=IFERROR(INDEX(Book_Data!$
Thanks,
Andrea
ASKER
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Excellent! Thanks so much for the quick turnaround on this, too!
regards, barry