Forum Discussion
Solved
Formula Working for Only Part of a Column in a Table
I have a formula in a Table that works for rows 4-16, then I get a #VALUE! error. I've looked at the input type and everything else I can think of but nothing works. Has anyone else experienced ...
Or
=IF(OR([@Container]=$T$4, [@Container]=$T$7, [@Container]=$T$14),[@[Per Piece w/ Discount Plus Shipping]],[@[Per Flat w/ Discount Plus Shipping]])*VLOOKUP([@Container],ecost7[[Container]:[Ecost Factor]],2,FALSE)
I believe this is what you were going for:
=LET(v,VLOOKUP([@Container],ecost7[#All],2,FALSE),IF(OR(G4=$T$4, G4=$T$7, G4=$T$14),N4*v,L4*v))
I tried this but am now getting a #NAME? error.