sgreenprice
New Member
- Joined
- Sep 21, 2017
- Messages
- 6
Good Afternoon,
I have a problem in which I need to create a dynamic list depending on a search criteria, which then looks at a column of data and returns all values adjacent to the matching search criteria. I've appended an image to hopefully make my query a little clearer.
I know I need to use INDEX and MATCHIF functions, and possibly VLOOKUP? But honestly I'm at odds with how I will use those functions to achieve what I need.
Do you guys have any suggestions? Thanks in advance!
Kind Regards,
Stephen
I have a problem in which I need to create a dynamic list depending on a search criteria, which then looks at a column of data and returns all values adjacent to the matching search criteria. I've appended an image to hopefully make my query a little clearer.
I know I need to use INDEX and MATCHIF functions, and possibly VLOOKUP? But honestly I'm at odds with how I will use those functions to achieve what I need.
Do you guys have any suggestions? Thanks in advance!
Kind Regards,
Stephen