Forum Discussion

Copper Contributor

Nov 15, 2022

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 ...

Formulas and Functions

HansVogelaar
Nov 15, 2022
ToddMulder

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)

ToddMulder

Copper Contributor

Nov 15, 2022

=IF(OR(G17=$V$4,G17=$V$7,G17=$V$14),N17*VLOOKUP(ecost[[#All],[Container]],ecost[#All],2,FALSE),L17*VLOOKUP(ecost[[#All],[Container]],ecost[#All],2,FALSE)) The column goes to row 797.

HansVogelaar
MVP
Nov 15, 2022
ToddMulder

Thanks. I fear I'd have to see the setup. Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
- ToddMulder
  Copper Contributor
  Nov 15, 2022
  HansVogelaar
  
  Here's the file. I hid the columns used in previous calculations but aren't referenced in this formula.
  Excel Formula Help.xlsx149 KB
  - HansVogelaar
    MVP
    Nov 15, 2022
    ToddMulder
    
    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)