|
|
#1
08-04-2013, 04:04 PM
|
|||
|
|||
Problem with Vlookup
I am trying to do a non-exact vlookup and having strange results.
I have a cell that has a calculated number, formatted as percentage. When I lookup that percentage in a table, it is returning N/A. Doing some testing with value in a formula , I can try different exact values, and some return a value, and others don't. No non-exact values return anything. I have attached an example spreadsheet. Any ideas what I'm doing wrong? 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Question: Will Vlookup work on this problem? | jnix612 | Excel | 1 | 07-27-2013 12:11 AM |
| VLookup formula Problem (salary plus (commission x sales)) | topgear2015 | Excel | 11 | 06-05-2013 09:02 PM |
 Can i do this with a VLookup?
|
foodstudent | Excel | 1 | 01-21-2011 12:34 AM |
| Using IF & VLOOKUP together | junction | Excel | 7 | 11-18-2010 05:15 AM |
|
Vlookup and If statement problem
|
bunnygum | Excel | 1 | 03-24-2009 05:10 AM |
Windows 7 64bit 
Office 2010 64bit
Threaded Mode