Index/Match possibly? Match data from one sheet to another

[kg0332]

I have a tab that in Column B2 a user will enter a number. Under a different tab I have a column of numbers beginning in A2 with a Corresponding number beginning in Column C2. I would like when a user enters a number in the first tab in Col B2 for excel to display all the Corresponding numbers that are in C2 of the second tab.

Hope this makes sense.

Example

B2 first tab a user enters 45131.

In the 2nd tab in A2 there are 600 different numbers. 45131 is listed 21 times in A2 with different numbers in C2

A2 C2
45131 201
45131 179
45131 301

I would like when 45131 is entered in B2 for the numbers in C2 that correspond with that number to be listed in a list in the 1st tab in Column L.


Like this

A2 L2
45131 201
179
301
Thanks for any assistance...

[protonLeah]

(How to) Upload a Workbook directly to the Forum
(please do not post pictures or links to worksheets)

• Click Advanced next to Quick Post button at the bottom right of the editor box.
• Scroll down until you see "Manage Attachments",
• Click the "Choose" button at the upper left (upload from your computer).
• Select your file, click "open", click "upload"
• Once the upload is completed the file name will appear below the input boxes in this window.
• Close the Attachment Manager window.
• Click "Submit Reply"

Note: Please do not attach password protected workbooks/worksheets
Ensure to disable any Workbook Open/Autorun macros before attaching!

[muss1210]

i would use a advanced filter it can be set up to filter on the same page or filter the results onto another page.


https://www.ablebits.com/office-addi...vanced-filter/