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))

HansVogelaar's avatar
HansVogelaar
MVP
May 10, 2021

fisherayda 

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

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

    HansVogelaar 

     

    It works perfectly! Thank you so much! 

     

     

Resources