Hi, new to this:
I have been battling with trying to extract data from a range of data and I am getting duplicate results:
See attached, in E2 I am putting in the name "Bob", with a formula =IFERROR(INDEX(B2:B11,MATCH($E$2,$A2:$A11,0)),"")
the result in G2,H2 and I2 have come from the first column with Bob or B5,C5 and D5
The next 3 rows come back with duplicate data, then when it gets to G6, H6, and I6 I am getting the rest of the data I am looking for
My question is" how do I stop it from duplicating, and only give me the 4 set of results I am looking for?, i.e B,C,D 4 to 8
Thank for the help
Jonathan
Bookmarks