Hello, I need help with a formula that will lookup vertically as well as horizontally to pull in a value into cell I70 on the first screenshot from what is entered on the spreadsheet in the second screenshot. I would like it to function so that when the value highlighted in cell I5 in the first screen shot is changed, it will update the value in cell I70 with the most recent data. In other words, when 7 is entered into cell I5 of the spreadsheet in the first screen shot, it will pull in 5,575 from cell K8 in the second screenshot into cell I70 in the first screenshot. When 8 is entered into cell I5 of the spreadsheet in the first screen shot, it will pull in 5,382 from cell L8 in the second screenshot into cell I70 into the spreadsheet in the first screenshot. So every time cell I5 in the first screenshot is updated, it will pull in the number that matches that department ID (column C in first screenshot and column B in second screenshot) as well as the matching pay period # in cell I5 in the first screenshot and row 5 of the second screenshot.
Screen shot 1:
Screen shot 2:
Screen shot 1:
Screen shot 2: