Hey Nick,
Sorry to jump on an older thread but I didn’t want to just past another one of the same kind of question. I took a look at the solution you posted for mina and while it makes sense its not wanting to work for me. I want to do the same thing as she is but for me the tables are in different sections.
I can use various things such as lookup and filter to grab the right information from the tables but then either I get ALL the information (in this case a phone number) or I get all the names listed as a reference.
Any idea how to make it work out so I can search for the number in a column associated with someones row and then pull the number it self in? I am wanting to do something similar with other bits of information as well but not sure if it’s possible or not.