3 way Lookup (Index Match) with different Sheets

[MBS]

Hi All,
I am using Excel 2013
I have records (month & year wise) for 3 vendors at 3 different sheets, in tabled format.
In summary sheet like to summarize data with 3 way selection. (Month, Year and Vendor)
I had done it with Month and Year for Each vendor (Sheet1, sheet 2, Sheet3) but unable to add 3rd criteria.
Please help

 

[Peter Bartholomew]

I use the most recent version of Excel 365 (insider beta) so it is unlikely that my solution would read across directly.

= LET(
      table,    CHOOSE(tblNumber,Table1,Table2.Table3),
      tblMnth,  CHOOSECOLS(table, 1),
      tblYr,    CHOOSECOLS(table, 2),
      selectedCols, DROP(table,,3),
      FILTER(selectedCols, (tblMnth=month)*(tblYr=year),"No matches")
  )

What should read across is the use of CHOOSE to select the vendor.