| 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 + |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Vlookup
Nikki,
In this context the word 'Pull' doesn't mean much to me. What are the inputs to the formula you require and from those inputs what result do you expect? Mike "Nikki" wrote: 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 + |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Vlookup
I have -15% up to about -150% and all over 0% works. The table below is a
lookup reference of ranges. If cell a1 is -75% give me <0 - make sense? "Mike H" wrote: Nikki, In this context the word 'Pull' doesn't mean much to me. What are the inputs to the formula you require and from those inputs what result do you expect? Mike "Nikki" wrote: 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 + |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Vlookup
Nikki,
Change the first line in your table to look like the one below and then use the formula =VLOOKUP(A1,H1:I12,2,TRUE) -9999999999 <0 0 0 - 9.9 0.1 10 -19.9 0.2 20 - 29.9 0.3 30 - 39.9 0.4 40 - 49.9 0.5 50 - 59.9 0.6 60 - 69.9 0.7 70 - 79.9 0.8 80 - 89.9 0.9 90 - 99.9 1 100 + Mike "Nikki" wrote: I have -15% up to about -150% and all over 0% works. The table below is a lookup reference of ranges. If cell a1 is -75% give me <0 - make sense? "Mike H" wrote: Nikki, In this context the word 'Pull' doesn't mean much to me. What are the inputs to the formula you require and from those inputs what result do you expect? Mike "Nikki" wrote: 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 + |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Vlookup
Try this;
Create a reference table in E1:F12 of the following -100 <0 0 0 - 9.9 0.1 10 -19.9 0.2 20 - 29.9 0.3 30 - 39.9 0.4 40 - 49.9 0.5 50 - 59.9 0.6 60 - 69.9 0.7 70 - 79.9 0.8 80 - 89.9 0.9 90 - 99.9 1 100 + In B1 enter the formula =IF(A1="","",VLOOKUP(A1,$E$1:$F$12,2,1)) copy down as needed. A value entered in column A should result with your appropriate range indicator in column B. Best wishes. Dave "Nikki" wrote in message ... I have -15% up to about -150% and all over 0% works. The table below is a lookup reference of ranges. If cell a1 is -75% give me <0 - make sense? "Mike H" wrote: Nikki, In this context the word 'Pull' doesn't mean much to me. What are the inputs to the formula you require and from those inputs what result do you expect? Mike "Nikki" wrote: 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 + |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Vlookup
It may have been obvious but my table was in H1 - I12
Mike "Mike H" wrote: Nikki, Change the first line in your table to look like the one below and then use the formula =VLOOKUP(A1,H1:I12,2,TRUE) -9999999999 <0 0 0 - 9.9 0.1 10 -19.9 0.2 20 - 29.9 0.3 30 - 39.9 0.4 40 - 49.9 0.5 50 - 59.9 0.6 60 - 69.9 0.7 70 - 79.9 0.8 80 - 89.9 0.9 90 - 99.9 1 100 + Mike "Nikki" wrote: I have -15% up to about -150% and all over 0% works. The table below is a lookup reference of ranges. If cell a1 is -75% give me <0 - make sense? "Mike H" wrote: Nikki, In this context the word 'Pull' doesn't mean much to me. What are the inputs to the formula you require and from those inputs what result do you expect? Mike "Nikki" wrote: 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 + |
| Reply |
| 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 | |||
Linear Mode
