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)
Here's the file. I hid the columns used in previous calculations but aren't referenced in this formula.
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 spoke too soon. It worked on the test worksheet I attached but when I type it into the full spreadsheet I get the same error. Is it possible other data in the spreadsheet, even if it's not used in the formula, can affect this?
- My apologies. After a little more digging, I've got it. Thanks again!
- This worked! Thank you!