Hello, I'm trying to make things at work more productive, and for that I'm trying to make an excel file that will access another file in the same folder and bring me the values that we always use, not everything on file 2 is useful for us.
So I have 2 excel file, file A is the one I'm working on, and file B is the one where the info is stored, and we receive it from a third party, File B always has the same layout, but different amount of info.
I successfully made a formula to find the coordinates of the info I need(varies from file to file,so it's not a fixed position), but i can't make it work to retrieve the info in spill, only 1 value.
I'm using index match to find the limit position of the table I'm looking for but since it match returns a number, I'm having trouble to make index return the values in between the limits.
Thank you in advance.
Bookmarks