| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I use VLOOKUP to nest more then 7 IF statements?
Hello,
I have 12 different values I would like to return based on a range of numbers. Right now, I have it set up to display the 7 most common of them through nested if statements via this formula: =IF(E5=250,"1.9",IF(E5=210,"1.8",IF(E5=170,"1.7 ",IF(E5=150,"1.6",IF(E5=140,"1.5",IF(E5=130,"1. 4",IF(E5=120,1.2,1))))))) How can I include the missing values using a different function? I had read to use either an index or lookup function, but don't know how to apply these. The missing ranges and values I am trying to add are 0-49:0.70, 50-89:0.90, 90-109:1.00, 250-299:1.90, =300:2.00. Any assistance would be highly appreciated. thanks! Yoshi |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can you combine VLOOKUP with a nest HLOOKUP? | Excel Discussion (Misc queries) | |||
| Syntax to Nest ISERROR with a VLookup | Excel Worksheet Functions | |||
| Syntax to Nest ISERROR with a VLookup | Excel Worksheet Functions | |||
| Nest vlookup within large function | Excel Worksheet Functions | |||
| How do I nest IF statements to only return value if both true? | Excel Worksheet Functions | |||
Threaded Mode
