I use INDEX/MATCH a lot instead of VLOOKUP. Much easier! I’m now trying to use it with variable data. I have multiple worksheets (monthly) that have the same row and column headers. On a summary worksheet, I want to use drop down boxes to select the worksheet, the column and the row. I don’t know how to write the formula so that the worksheet can be the cell on my summary sheet (i.e. replace Jan with Summary!A6). Plus I don’t know if I should do the same thing with the two MATCH statements (the rows and columns are identical on all the worksheets). I’ve done some research and thought maybe an INDIRECT statement would work but that’s way above my skill level.

=INDEX(Jan!$2:$286,MATCH(Summary!$B6,Jan!$A$2:$A$286,0),MATCH(Summary!$C6,Jan!$1:$1,0))

Your help would be greatly appreciated!