Forum Discussion
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...
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.
=HLOOKUP(B2,'Haulier log'!$C$3:$J$4,2,FALSE)
I understand your return data in sheet "Haulier log" is in horizontal order as shown in the attached file. Maybe the above formula is what you are looking for.