Forum Discussion

JSLINDSAY's avatar
JSLINDSAY
Copper Contributor
Dec 13, 2021
Solved

If formula with multiple conditions

Hello   How do I do an if formula with multiple conditions. I think what I am looking for would be an If And formula but I am struggling to work out how to do it.   I currently have =IF(B1='Hauli...
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    Dec 13, 2021

    JSLINDSAY 

    In E3:

    =INDEX('Haulier Log'!$C$4:$AG$16,MATCH($A3,'Haulier Log'!$A$4:$A$16,0),MATCH($B$1,'Haulier Log'!$C$3:$AG$3,0))

    Fill down.

    See the attached version.

    I changed the dates in row 3 of the Haulier Log sheet to dates in this month (you had dates in January of 2022), and entered fake data below.

HansVogelaar's avatar
HansVogelaar
MVP
Dec 13, 2021

JSLINDSAY 

You can probably use one of the lookup functions, but we need details about your setup. Could you attach a sample workbook without sensitive information?

JSLINDSAY's avatar
JSLINDSAY
Copper Contributor
Dec 13, 2021

HansVogelaar 

 

Thank you, I have attached a copy.

 

I want the formula to go into column E on the tabs named the days of the week.

 

So really when the date in the haulier log matches the day I am planning, I want the info to be populated.

 

Thanks

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Dec 13, 2021

    JSLINDSAY 

    In E3:

    =INDEX('Haulier Log'!$C$4:$AG$16,MATCH($A3,'Haulier Log'!$A$4:$A$16,0),MATCH($B$1,'Haulier Log'!$C$3:$AG$3,0))

    Fill down.

    See the attached version.

    I changed the dates in row 3 of the Haulier Log sheet to dates in this month (you had dates in January of 2022), and entered fake data below.

Resources