Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 01-06-2016, 03:16 PM
gebobs gebobs is offline Nested IF Windows 7 64bit Nested IF Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Lots of ways to skin that cat. Here's one.

On the left is the lookup table with the lower bound of your intervals under Score and the corresponding Level to their right.

To the right, enter a score into the cell in E2 and it returns the level in E3.

This is the formula:
=VLOOKUP(E2,$A$2:$B$6,2)

What that does is look up the value of E2 in $A$2:$B$6 that is either equal to or lower and closest to it. It then returns the corresponding value it finds in Column 2 of that range.
Attached Files
File Type: xlsx Score.xlsx (8.0 KB, 11 views)
Reply With Quote
 

Tags
nested



Similar Threads
Thread Thread Starter Forum Replies Last Post
nested if and averageA windseaker Excel 0 08-14-2015 04:13 PM
Nested IF using if and nested vlookup wentworth16238 Excel 5 06-14-2015 12:59 PM
Nested Countif Function bdavidson22 Excel 0 12-19-2014 12:36 PM
Nested Vlookup Help asluder2000 Excel 2 11-14-2014 11:00 PM
Nested IF Nested IFs JimS378 Excel 7 05-03-2011 08:20 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:27 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft