Thread: Lookup Table
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Nikki Nikki is offline
external usenet poster
 
Posts: 184
Default Lookup Table

I have created the table below to vlookup a % but I can't seem to figure out
how to get less than 0 to work for me. Can anyone fill in the below 0 lookup?

-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