Search for matches from columns on separate sheets. [Solved/Closed]

Question

Search for matches from columns on separate sheets. [Solved/Closed]

Report

Tim - Oct 1, 2015 at 03:14 PM
Tim - Oct 6, 2015 at 06:54 PM

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.

Search for matches from columns on separate sheets.
Excel partial match two columns - How-To - Excel
Excel match two columns and output third ✓ - Forum - Excel
Copy same column from multiple sheets - How-To - Excel
Excel vba search for value in column - How-To - Excel
Chrome search exact match - How-To - Google Chrome

1 reply

Ask a question

rizvisa1 · Answer 1 · 2015-10-06T15:13:33-0400

Answer 1 / 1

rizvisa1

Posts: 4476
Registration date: Thursday January 28, 2010
Status: Contributor
Last seen: August 2, 2020

768
Oct 6, 2015 at 03:13 PM

what you have in mind when you say " Once A1 has been checked, check A2,"

Report

Tim
Oct 6, 2015 at 06:54 PM

Thanks, but I was able to figure it out.

Search for matches from columns on separate sheets. [Solved/Closed]

1 reply

Your reply

Subscribe To Our Newsletter!