Search for matches from columns on separate sheets.
Solved/Closed
Hello,
I've got a problem that is stumping me, and I hope you all can help. I have two sheets in my workbook and I would like to have a formula, script, or macro that would check A1 of sheet 1 for a matching value in Column A of sheet 2. If a match is found, and there may be multiple, display all rows of data with that match. Once A1 has been checked, check A2, and so on for all of Column A of sheet 1.
I hope that made sense, and thank you all in advance if you help me out.
I've got a problem that is stumping me, and I hope you all can help. I have two sheets in my workbook and I would like to have a formula, script, or macro that would check A1 of sheet 1 for a matching value in Column A of sheet 2. If a match is found, and there may be multiple, display all rows of data with that match. Once A1 has been checked, check A2, and so on for all of Column A of sheet 1.
I hope that made sense, and thank you all in advance if you help me out.
Related:
- Search for matches from columns on separate sheets.
- Search from google usa - Guide
- How to search for words on websites - Guide
- Sheet right to left google sheets - Guide
- Tweetdeck larger columns - Guide
- How to search nearby friends on facebook - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Oct 6, 2015 at 03:13 PM
Oct 6, 2015 at 03:13 PM
what you have in mind when you say " Once A1 has been checked, check A2,"
Oct 6, 2015 at 06:54 PM