IF/AND/VLookup Formula Error
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
 10.7K Get Help
 63 Global Discussions
 68 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 55 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 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!