 |
|||||||
| |||||||
|
||||||||
| Forum Tutorials && Noobs Solutions All Noobs Please search here SOLUTIONS TO GENERAL FORUM USAGE PROBLEMS" |
| Notices |
| Your link here | Your link here | Your link here | Your link here | Your link here |
  |
| Bookmarks |
|
|
LinkBack (1) | Thread Tools | Display Modes |
07-16-2008, 06:11 PM
|
 #1 (permalink)
|
 
|
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  |
  |
|
|
    
|
| The Following User Says Thank You to Dreamsilver For This Useful Post: | ||
|
abhi.imt.nag (07-16-2008)
| ||
| Click here to Donate to remove the Adverts. | |
|
|
|
|
|
«
Previous Thread
|
Next Thread
»
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| [EXCEL Tutorial]Change Text In Upper Case Of Multiple Cells In Excel | vj_ip | Softwares | 1 | 06-21-2008 02:57 AM |
| Excel Best Practices for Business: Covers Excel 2003, 2002, and 2000 | hacks | Ebooks,tutorials & Other Stuff | 0 | 05-14-2008 06:02 AM |
| Excel for the CEO | Nawainruk | Ebooks,tutorials & Other Stuff | 1 | 01-15-2008 07:18 AM |
| Create For Excel 3.0.0.322 | KoOL | Appz Zone | 0 | 11-28-2007 02:12 PM |
| Assist For Excel 1.6.0.586 | KoOL | Appz Zone | 0 | 11-28-2007 02:10 PM |
