Forum Discussion
Solved
How to pull specific data from one sheet and transfer to another based on common name
Hi y'all! I have two different sheets. In Sheet A, I have names, and addresses broken down by address, city, and zip code. In Sheet B, I have specific/select names from Sheet A that need to have their addresses pulled and copied onto Sheet B. How can I go about doing this?
=INDEX(B$3:B$11,MATCH($G3,$A$3:$A$11,0))
You can use INDEX and MATCH. In the example the database and the result are in the same sheet for illustration. The formula is in cell H3 and filled across range H3:J11.
2 Replies
=INDEX(B$3:B$11,MATCH($G3,$A$3:$A$11,0))
You can use INDEX and MATCH. In the example the database and the result are in the same sheet for illustration. The formula is in cell H3 and filled across range H3:J11.
- This works. Thank you!
