All in one forum - Applications | Games | E-Books | Music, Movies & Videos | Mobile Stuff | Live Discussions | Webmaster Stuff | Many More | Community to Hang Out & Stick to - View Single Post

Dreamsilver · 07-16-2008, 06:11 PM

Excel Help.JPG

Is there a way to add a range for vlookup function?

My current function to get the Remarks is this

=VLOOKUP(G4,$K$5:$L$7, 2)

But as you can see from the picture, there's an average column which has numbers to a decimal place. So how can I add a range in the vlookup so that it will be more accurate.

For example 'Exceed Expectation' require a on the dot 50 in the average. How do i change the value in the vlookup table so that the range will become '40-60' for example

07-16-2008, 06:11 PM	#1 (permalink)
Dreamsilver User Info Join Date: May 2008 Achievements Posts: 104 Casino Cash: $21650 Total Points: 10,263.69 Donate Reputation: 880	Need Excel Help Excel Help.JPG Is there a way to add a range for vlookup function? My current function to get the Remarks is this =VLOOKUP(G4,$K$5:$L$7, 2) But as you can see from the picture, there's an average column which has numbers to a decimal place. So how can I add a range in the vlookup so that it will be more accurate. For example 'Exceed Expectation' require a on the dot 50 in the average. How do i change the value in the vlookup table so that the range will become '40-60' for example