Thread: [Solved] Problem with Vlookup
View Single Post
 
Old 08-04-2013, 04:04 PM
56_kruiser 56_kruiser is offline Windows 7 64bit Office 2010 64bit
Novice
  
Join Date: Nov 2012
Posts: 26
56_kruiser is on a distinguished road
Default 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?
Attached Files
File Type: zip Example.zip (9.3 KB, 10 views)
Reply With Quote