ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   look up (https://www.excelbanter.com/excel-programming/375812-look-up.html)

B0428

look up
 
i need to be able to look up a name that belongs to a number of different
groups, i also need to say to which group/s does this name belong to.

please help

e.g Group A, Group B, Group C
mike bongani Peter
David Nichole Mike
anne Fred Fred
Nichole Mike nani

in this example we have 3 different group names A,B,C. Each group has a list
of names, now i need to find a way to being able to find "Fred" and be able
to say from which group/s does he belong to



Gary''s Student

look up
 
Ediy Find then enter the name and select find all

Find will present you with a nice list of all of the occurances.
--
Gary's Student


"B0428" wrote:

i need to be able to look up a name that belongs to a number of different
groups, i also need to say to which group/s does this name belong to.

please help

e.g Group A, Group B, Group C
mike bongani Peter
David Nichole Mike
anne Fred Fred
Nichole Mike nani

in this example we have 3 different group names A,B,C. Each group has a list
of names, now i need to find a way to being able to find "Fred" and be able
to say from which group/s does he belong to




All times are GMT +1. The time now is 02:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com