Excel Index Array changes base on using inputting the desired worksheet =INDEX('XYZpayWS'!F9:F63,MATCH(InputWS!E10,'XYZpayWS'!A9:A63,0))