Nov 15 2022 07:31 AM
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 this? Any ideas?
Nov 15 2022 07:47 AM
What is the formula?
Nov 15 2022 07:50 AM
Nov 15 2022 08:00 AM
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?
Nov 15 2022 08:10 AM
Here's the file. I hid the columns used in previous calculations but aren't referenced in this formula.
Nov 15 2022 08:25 AM
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))
Nov 15 2022 08:51 AM
SolutionOr
=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)
Nov 15 2022 09:06 AM
Nov 15 2022 09:15 AM
Nov 15 2022 09:46 AM
Nov 15 2022 09:54 AM
Nov 15 2022 08:51 AM
SolutionOr
=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)