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

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

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