Hi –
I need assistance creating a formula with match statement(s). My current formula isn’t reading all my columns and gives me an “N/A” the moment I change “FOB” <–column I am referring to.
Heres my current formula – =VLOOKUP(XLOOKUP(VALUE($A16),VALUE(FOB!$A:$A),FOB!$D:$D,,0),$U$5:$AB$13,MATCH($G$5,$U$5:$AB$5,0))*$O16
Which works, because I want the total to be multiplied by the percentage to give me a value for a specific day.
Appreciate any help