IF/AND/VLookup Formula Error
Options
I am trying to create a formula that requires a vlookup to another sheet. The formula reads:
=IF(VLOOKUP(Address@row, {Ranking Matrix Range 3}, 16, 1) < 28, 100, IF(VLOOKUP(Address@row, {Ranking Matrix Range 3}, 16, 1) = 28, 50, IF(AND(VLOOKUP(Address@row, {Ranking Matrix Range 3}, 16, 1) >= 29, <39), 40, 0)))
Essentially, I need the formula to determine if a number the vlookup is returning is the following:
Less than 28 = 100
28 = 50
Between 2939 = 40
Can anyone help? This is returning a Invalid Operation message and I know it is because of the IF(AND(VLOOKUP
Thanks!!
Best Answer

Never mind!!! I have figured it out!
Answers

Never mind!!! I have figured it out!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.2K Get Help
 320 Global Discussions
 197 Industry Talk
 415 Announcements
 4.2K Ideas & Feature Requests
 126 Brandfolder
 153 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 276 Events
 34 Webinars
 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!