I have an issue where I am reading the range of an excel sheet that contains a string in the same column but on several rows. I am trying to get the cell value using lookup range so I can get the data needed from the columns next to said keyword/string that I am using lookup range on.
However the only thing I manage to get is the same output (the first value it finds) over and over again and I am not sure how to get to the next value.
I will attach a dummy excel to show better what it is I am trying to achieve!
In the dummy file, I am searching for the string “Apple” with lookup range and use the cells position to get the rest of the columns values (B-E). Then go on to the next position of “Apple” and do the same thing and add the values together.
DummyFile.xlsx (8.1 KB)