EXCEL: Find name and return multiple values

rk14

New Member
Joined
Aug 30, 2023
Messages
1
Office Version
  1. 365
Platform
  1. Windows
Hello all,

I am a newbie with excel, so I'm hoping someone can help out.

in the workbook I'm working on, I have multiple tabs with data spread out.
  • Tab 1 contains a list of resources and the dates they will end support. Unfortunately, some list the full name, and others list just the first name.
  • Tab 2 contains a list of tools that the resources are is using. the resources can be supporting multiple applications. so in row 1-10, they could be supporting tools 2, 4, 5, 8-10.


I would like the following in tab 1:
- to be able to look up the resource firstname(cell B2) in Tab 1, find the matching name in Tab 2, and list all the tools they are supporting; separated by a semicolon().


I have looked through many tutorials but I think the nested statements are tripping me up


 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
Hello all,

I am a newbie with excel, so I'm hoping someone can help out.

in the workbook I'm working on, I have multiple tabs with data spread out.
  • Tab 1 contains a list of resources and the dates they will end support. Unfortunately, some list the full name, and others list just the first name.
  • Tab 2 contains a list of tools that the resources are is using. the resources can be supporting multiple applications. so in row 1-10, they could be supporting tools 2, 4, 5, 8-10.


I would like the following in tab 1:
- to be able to look up the resource firstname(cell B2) in Tab 1, find the matching name in Tab 2, and list all the tools they are supporting; separated by a semicolon().


I have looked through many tutorials but I think the nested statements are tripping me up


Can you please submit representative examples of your data for the two worksheets using XL2BB?
 
Upvote 0

Forum statistics

Threads
1,223,884
Messages
6,175,175
Members
452,615
Latest member
bogeys2birdies

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top