Skip to Content
0
Former Member
Feb 24, 2014 at 01:18 AM

Need to look up one value and need to get all rows and columns

18 Views

Hello,

My scenario - I need to lookup at a value in an array and get all the rows and columns that have that value

For example:

Country || City || Revenue

India || Hyderabad || 100

India || Delhi || 150

US || Chicago || 200

US || NewYork || 180

US || Vegas || 200

I want to get the following result by looking at value 'US' and project on my bar chart

US || Chicago || 200

US || NewYork || 180

US || Vegas || 200

I am not sure how can I do this with Index & Match. Any thoughts?