IF Cell value Equals

[mtagliaferri]

Hi All,

I am stuck on something very basic....or not...

I need to return a value in a cell based on what another cell value is, specifically:

A1 contains a Lookup/Array formula which will return either 100,75 or 50 I would like D1 to display 125 if A1 is 100, display 90 if 75 and finally display 65 if 50.

I cant get round it....

Any help
Thanks

 

[jtakw]

Hi,

Try either one of these:

Book1
	A	B	C	D	E
1	100			125	125
2	75			90	90
3	50			65	65
Sheet570

Cell Formulas
Range	Formula
D1	=LOOKUP(A1,{50,75,100},{65,90,125})
E1	=IF(A1>75,125,IF(A1>50,90,65))

 

[mtagliaferri]

Thanks jtakv, both did nicely the trick.
I did not take that approach... I was adamant it should have worked with the IF statement and OR and the syntax of the first example never thought of the LOOKUP.

Learn in progress...

 

[jtakw]

You're welcome, glad you got a working solution.

 

[mtagliaferri]

I thonk I am back at square one....

I have added the LOOKUP formula in
Cell I4 =IFERROR(INDEX(Data!$A$2:$L$1015, SMALL(IF($B$4=Data!$A$2:$A$1015, ROW(Data!$A$2:$A$1015)-MIN(ROW(Data!$A$2:$A$1015))+1, ""), ROW(L1)),COLUMN(L1)),"")
Cell K4 =LOOKUP(I4,{50,75,100},{65,90,125})

I am getting an error #N/A although the Lookup formula works correctly and returns either 100,75 or 50.

How do I get the result from the cell containing the lookup formula?

Thanks again!

 

[jtakw]

I'm not understanding your new question...

Are you having problems with the LOOKUP formula, or are you having problems with your I4 IFERROR/INDEX formula ?