I am trying to capture a set of values from a sheet, which has several rows with the match I am looking for.
I have used the Index and Match functions to capture the first value in column 2, where column A matches a specific value shown in D1
with the following:
=INDEX($A1:$B$8,MATCH($D$1,$A:$A,FALSE),2).
I 'fiddled' this on line 2 to capture the 2nd value by changing the range of the index function to $A2:$B8 and so on.
However this 'fudged' approach means that I can get a value where the value in Col A no longer matches D1.
I have attached an example.
I know there is better way to achieve what I would like - am just working at too basic a level of Excel.
Can anyone shine a light on my challenge?
Hopefully....
Bookmarks