Formula Help for Vlookup and IF

[Deleted]

I have a cell that I want to lookup a certain discount based on a user number and lookup that discount based on 3 different cells

b3=enter users

c4,c5,c6= options to enter y

if c4 is "y", I want a discount to be looked up from a named range, if c4 AND c5 are "y", then I want it to look at a different named range, and if c4, c5, and c6 are "y" then I want the discount to be looked up from a third named range This is what I have so far, but it's only pulling up the 1st lookup discount, but it is correct

=iferror(if(C4="y",vlookup(B3,SilverUsers,3),if(and(C4="y",C5="y"),vlookup(B3,GoldUsers,3),if(and(C4="y",C5="y",C6="y"),vlookup(B3,PlatinumUsers,3)))))

[#2]

when I say correct, I mean it is looking up the appropriate discount

[#3]

You all will like this. I put it in the reverse order and it worked