Match Collect Formula?

Angie Hatfield

I have one sheet that has a list of Account Numbers and Account Names. This list is managed by one Department who adds to it as needed.

I have a second sheet, managed by another Department who uses the Account Numbers and manually enters them. They don't enter the Account Names. They haven't been needed and could be mispelled if manually entered.

We now need to add the Account Names to the second sheet. I would like the names to auto-fill from the other sheet but have not figured out a formula to look it up and pull it in without being an exact row match.

Any ideas?

Thank you

Paul Newcome

You are going to want to use something like this...

=INDEX({Other Sheet Account Name Column}, MATCH([Account Number]@row, {Other Sheet Account Number Column}, 0))

Paul Newcome

You are going to want to use something like this...

=INDEX({Other Sheet Account Name Column}, MATCH([Account Number]@row, {Other Sheet Account Number Column}, 0))

Angie Hatfield

Paul,

Thank you so very much. This works exactly as I needed.

I greatly appreciate your knowledge and help with this.

Angie Hatfield

Paul Newcome

Happy to help! 👍️