Tried to vlookup and hlookup , that seemed to not work so Index Match seems best.
I have different sensitivities across the horizationally( ex: -30,-20, 0, 20, 30) in one sheet and vertically in another. Any way to index match this?
In this screen shot the portfolio name will be listed once becasuse sensitivites go horizontal.
In this screenshot, portfolio names are listed multiple times because sensitivities go vertical.
My goal is to provide a side by side comparison so I can calculate differences differences between these 2 sheets.
Any ideas would be appreciated