| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nested Vlookup and IF function????
Hi all, i am trying to have a Vlookup statement look at a table depending on the value in B1, IF I9 =34 Then IF the value of B1 is =<5 Look at column 2 ElseIf B1 =6 AND =<12 Then Look at column 3 ElseIf B1 =13 AND =<20 Then Look at column 4 ElseIf B1 =21 AND =<36 Then Look at column 5, I know what i'm trying to get at but lack the knowledge to put all the above in to a function in I10, DeductionsAdditions is the named range i am looking up from. =VLOOKUP(I9,DeductionsAdditions,6,0) Can anyone help here? Regards, Simon -- Simon Lloyd ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.excelforum.com/member.php...fo&userid=6708 View this thread: http://www.excelforum.com/showthread...hreadid=541937 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nested IF Function and VLookup Alternatives | Excel Worksheet Functions | |||
| How do I access data stored in a SQL server for vlookup function? | Excel Worksheet Functions | |||
| VLOOKUP Function using Data Ranges. | Excel Worksheet Functions | |||
| Array Function with VLOOKUP | Excel Worksheet Functions | |||
| Nested if, sum & vlookup Function | Excel Worksheet Functions | |||
Threaded Mode
