Multiple If Stmts

[Kgov]

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,(VLOOKUP($I8,H95:M173,3,IF($H8=3,(VLOOKUP($I8,H176:M254,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

 

[Mike H]

Hi,

Try it this way

=CHOOSE(H8,VLOOKUP(I8,H14:M92,3),VLOOKUP(I8,H95:M173,3),VLOOKUP(I8,H176:M254,3))

Mike

 

[Kgov]

Sweet it worked! Thank you!

Hi,

Try it this way

=CHOOSE(H8,VLOOKUP(I8,H14:M92,3),VLOOKUP(I8,H95:M173,3),VLOOKUP(I8,H176:M254,3))

Mike