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
|