Nested If Contains Function Returning #No Match

Garrett.Ricker
Garrett.Ricker ✭✭✭
edited 09/12/23 in Formulas and Functions

Having and issue with a nested =IF(CONTAINS( function returning a result of #NO MATCH. Formulas work independently of each other just not nested. I also confirmed the "search value" within the VLOOKUP is on the lookup table. What am I missing?


=IF(CONTAINS("ABC", [DC Location]:[DC Location]), VLOOKUP([Lane Concat w/ Supplier Name]@row, {3A. DC Rate Capture Sheet - ABC Range 1}, 26, false), IF(CONTAINS("XYZ", [DC Location]:[DC Location]), VLOOKUP([Lane Concat w/ Supplier Name]@row, {3A. DC Rate Capture Sheet - XYZ Range 1}, 26, false)))

Tags:
«1

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!