| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple If Stmts
I've attempted to create a formula that by changing the value in one
designated cell would look up the the value in different vlookup ranges. the formula is: =IF($H8=1,(VLOOKUP($I8,$H$14:$M$92,3,IF($H8=2,(VLO OKUP($I8,H95:M173,3,IF($H8=3,(VLOOKUP($I8,H176:M25 4,3,0))))))))) so if H8=1 then it would look up the above reference and return the value in column 3. The formula works until I try and add multiple if stmts. Could use your help....thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Multiple If Stmts
Hi,
Try it this way =CHOOSE(H8,VLOOKUP(I8,H14:M92,3),VLOOKUP(I8,H95:M1 73,3),VLOOKUP(I8,H176:M254,3)) Mike "Kgov" wrote: I've attempted to create a formula that by changing the value in one designated cell would look up the the value in different vlookup ranges. the formula is: =IF($H8=1,(VLOOKUP($I8,$H$14:$M$92,3,IF($H8=2,(VLO OKUP($I8,H95:M173,3,IF($H8=3,(VLOOKUP($I8,H176:M25 4,3,0))))))))) so if H8=1 then it would look up the above reference and return the value in column 3. The formula works until I try and add multiple if stmts. Could use your help....thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Multiple If Stmts
Sweet it worked! Thank you!
"Mike H" wrote: Hi, Try it this way =CHOOSE(H8,VLOOKUP(I8,H14:M92,3),VLOOKUP(I8,H95:M1 73,3),VLOOKUP(I8,H176:M254,3)) Mike "Kgov" wrote: I've attempted to create a formula that by changing the value in one designated cell would look up the the value in different vlookup ranges. the formula is: =IF($H8=1,(VLOOKUP($I8,$H$14:$M$92,3,IF($H8=2,(VLO OKUP($I8,H95:M173,3,IF($H8=3,(VLOOKUP($I8,H176:M25 4,3,0))))))))) so if H8=1 then it would look up the above reference and return the value in column 3. The formula works until I try and add multiple if stmts. Could use your help....thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nested 'If" stmts | Excel Discussion (Misc queries) | |||
| Creating macros with if stmts | Excel Discussion (Misc queries) | |||
| Monthly bank stmts | Excel Worksheet Functions | |||
| view multiple files in multiple windows on multiple screens. | Excel Discussion (Misc queries) | |||
| IF Statement that's conditional on multiple IF Stmts in other cell | Excel Worksheet Functions | |||
Linear Mode
