Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup
Can anyone help me set up the lookup to pull <0 as shows in the table below?
What I have so far is -0.01 but it's not pulling anything. Thanks for your help. -0.01 <0 0.00 0 - 9.9 0.10 10 -19.9 0.20 20 - 29.9 0.30 30 - 39.9 0.40 40 - 49.9 0.50 50 - 59.9 0.60 60 - 69.9 0.70 70 - 79.9 0.80 80 - 89.9 0.90 90 - 99.9 1.00 100 + |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLookUp - Does the VLookUp return the exact information? | Excel Worksheet Functions | |||
Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |