Hey all,
I'm working with a workbook containing a lot of data from 3rd party vendors for a company project, and I'm using separate workbooks for each supplier I get data from. I'm using INDEX MATCH to pull in data from other workbooks, using the formula:
=INDEX([Ababa.xlsx]Sheet1!$D$2:$D$93,MATCH([Ababa.xlsx]Sheet1!$A2,[Ababa.xlsx]Sheet1!$A$2:$A$93,0))
with the variable cell being $A2 so that i can drag down and fill the columns easier. However, because I'm working with filtered columns the row numbers arent in exact order (eg. I'll have row 1073, then 1075, 1079, etc.) so when i drag down, the variable cell will go the same difference between cell numbers as the difference between row numbers. In this case, $A6 will be row 1073 but when i drag down to row 1075 (the next row), itll be $A8 instead of $A7.
Is there a way I can make it to where when I drag down, the variable cell will go down uniformly instead of trying to match the row number difference?
Bookmarks