| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Vlookup Help
I cant figure out what I am doing wrong.
Why wont my lookup bring me back 2.7 ? This is what Im getting: If I do =VLOOKUP(a6*100,a1:b4,2) = 2.5 or if I do =VLOOKUP(a6*100,a1:b4,2,0) = #N/A a b 1 6.875 -2.375 2 7.000 -2.500 3 7.125 -2.750 4 7.250 -3.375 5 6 7.125% |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Have Vlookup return a Value of 0 instead of #N/A | Excel Worksheet Functions | |||
| make a vlookup using a variable path | Excel Worksheet Functions | |||
| vlookup data hidden within worksheet | Excel Worksheet Functions | |||
| Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
| VLOOKUP not working | Excel Worksheet Functions | |||
Threaded Mode
