A
Andy
hi is there a way to use the lookup function and return all the values in ONE
cell that match the criteria, and not just the first or largest one?
Thanks
cell that match the criteria, and not just the first or largest one?
Thanks
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Gary''s Student
Use a User Defined Function
M
Mike H
Hi,
I assume this is related to your previous post. How about a UDF. Alt+F11 to
open VB editor, Right click 'This Workbook' and insert module and paste the
code below in on the right
Call with
=ListProjects(A1:A100,A1)
Where a1 - a100 is your list of names and a1 is the name your looking for.
Function ListProjects(rng As Range, mgr As String) As String
For Each c In rng
If c.Value = mgr Then
ListProjects = ListProjects + c.Offset(, 1).Text & " , "
End If
Next
End Function
Mike
I assume this is related to your previous post. How about a UDF. Alt+F11 to
open VB editor, Right click 'This Workbook' and insert module and paste the
code below in on the right
Call with
=ListProjects(A1:A100,A1)
Where a1 - a100 is your list of names and a1 is the name your looking for.
Function ListProjects(rng As Range, mgr As String) As String
For Each c In rng
If c.Value = mgr Then
ListProjects = ListProjects + c.Offset(, 1).Text & " , "
End If
Next
End Function
Mike