Offset Match Index Question

[JPerkins26]

Hello,

I am trying to figure out how to have a Value move from a different sheet next to my reference cell on my main sheet. The kicker is the data where the cell i want to return is set up like a table and i want it to be able to be dynamic with the reference Cell and the lookup based of the reference.

This is the Main sheet where i want the cell to return to in Col b based of Col A

This is the tables i want the data to come from. I want the Highlighed field to move over next to the same Creditor.

 

[Eric W]

Welcome to the MrExcel forum!

Not tested, since I didn't want to retype all your data, but try:

=INDEX('Credit Report Lines'!$E$2:$E$1000,MATCH(A54,'Credit Report Lines'!$A$2:$A$1000,0)+2)

For subsequent columns you'll need to change the column you're pulling from, and the offset (in red).

 

[JPerkins26]

Thank you so much. I have been racking my brain over this for 2 days. It worked.

 

[Eric W]

Happy to help. Thanks for the feedback. ?