Thread: Vlookup
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Nikki Nikki is offline
external usenet poster
 
Posts: 184
Default 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 +