Forum Discussion

fisherayda's avatar
fisherayda
Copper Contributor
May 10, 2021
Solved

Index Match with 4 Variables

Hello!   I am a Windows user, using Version 2104 of excel.    Each day I receive a spreadsheet containing four variables with the total number of items the customer would like for that day.    ...
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    May 10, 2021

    fisherayda 

    =INDEX(W324:W337,MATCH(1,INDEX((S324:S337=D324)*(T324:T337=E324)*(U324:U337=F324)*(V324:V337=G324),,),0))

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
May 10, 2021

fisherayda 

That could be like

=INDEX(W324:W337,
   MATCH(1, INDEX(
      (D324=S324:S337)*
      (E324=T324:T337)*
      (F324=U324:U337)*
      (G324=V324:V337)
       ,0), 0)
)

Resources