IF.., AND.., OR.., Statement

[roughleg]

Two copies of my first post came up and I deleted one by now both are gone, so here it goes again.
I need to return the values in different ranges based on the results of the following match. If the result is between 1 and 3 then return Z1, if the result is between 4 and 9 then return X1, if the result is greater than 10 then return Y1. If tried several if statements and I can't seem to make them work.
=INDEX($A$2:$K$275,MATCH($W$1,$A$2:$A$275,0),10)
Thanks,
Skip

 

[texasalynn]

try this

=IF(AND(A1>0,A1<4),Z1,IF(AND(A1>3,A1<10),X1,IF(Y1>9,Y1,"not")))

 

[roughleg]

Well, I was trying to do it all in one statement, but I can see how I can get what with you example.
Thanks,
Skip

 

[Scott Huish]

Assuming your result in A1, perhaps:

=INDEX(X1:Z1,,LOOKUP(A1,{1,3;4,1;10,2}))

 

[Von Pookie]

Two copies of my first post came up and I deleted one by now both are gone, so here it goes again.

That was me, sorry about that. I locked and deleted one, and apparently you deleted the other one in the meantime. But I couldn't remember the username of who had posted it to let them (you) know about the mixup.