T
Trish
I am comparing our current AP Check Run to balances owed from our Customers.
The names do not tie in exactly so I am using a index/match based on the
first five characters of each list.
I need, however, for the formula to work in a way that it will pull up more
than one result if they match. My current formula is
=INDEX(F:F,MATCH(K20,L:L,0)). The problem is that it pulls the first match
and then goes on to the next.
Thanks for any help you can give.
Trish
The names do not tie in exactly so I am using a index/match based on the
first five characters of each list.
I need, however, for the formula to work in a way that it will pull up more
than one result if they match. My current formula is
=INDEX(F:F,MATCH(K20,L:L,0)). The problem is that it pulls the first match
and then goes on to the next.
Thanks for any help you can give.
Trish