Hello Experts -
I need to search Spr!A9:A153 for the value in cell A25 and return the value in the cell below it and beside it. Then for the next 5 rows, I need the data another row down. Attached in an example with 3 tabs, Spr, Lamar, CO and Example. Lamar, CO is what I am getting, Example is what the end result needs to be.
I have tried using the offset and match functions and those work, but only for the 1st row, I cant figure out how to get the rows below that.