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.
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
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: Find name and return multiple values
Cross-posted at https://www.mrexcel.com/board/threads/excel-find-name-and-return-multiple-values.1244241/ 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...
www.excelforum.com