Help with Nested If AND statement

[thewiseguy]

Hi all,

I am having a difficult time combining these 4 individual statements. Can anyone help?

=IF(E5<21,Helper!U2)
=IF(AND(e5>20,e5<51),Helper!v2,"")
=IF(AND(e5>50,e5<101),Helper!w2,"")
=IF(e5>100,Helper!x2)


Many thanks in advance!

 

[CA_Punit]

Deleted

 

[Fluff]

How about
=if(E5<21,Helper!u2,if(e5<51,Helper!V2,if(E5<101,Helper!W2,Helper!X2)))

 

[CA_Punit]

Book1
	E	F	G	H	I	J	K
2
3
4				0	Helper!U2
5	21			21	Helper!U2
6				51	Helper!V2
7				101	Helper!W2
8				99999	Helper!x2
9
10	Helper!U2
11
12	Use =INDIRECT(LOOKUP(E5,H4:H8,I4:I8)) to return the cell references
13
14
15
Sheet2

Cell Formulas
Range	Formula
E10	E10	=LOOKUP(E5,H4:H8,I4:I8)

 

[thewiseguy]

excellent, thank you both!

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[CA_Punit]

Sorry for the Wrong lookupvalue

0​	Helper!U2
21​	Helper!V2
51​	Helper!W2
101​	Helper!X2

 

[thewiseguy]

Sorry for the Wrong lookupvalue

0​	Helper!U2
21​	Helper!V2
51​	Helper!W2
101​	Helper!X2

no worries - i understood what you were doing once I saw it. thank you again