# IF Cell value Equals

#### mtagliaferri

##### Board Regular
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

### Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.
Hi,

Try either one of these:

Book1
ABCDE
1100125125
2759090
3506565
Sheet570
Cell Formulas
RangeFormula
D1=LOOKUP(A1,{50,75,100},{65,90,125})
E1=IF(A1>75,125,IF(A1>50,90,65))

Last edited:
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...

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

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!

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 ?

Replies
1
Views
134
Replies
9
Views
557
Replies
7
Views
377
Replies
3
Views
122
Replies
4
Views
231

Threads
1,203,639
Messages
6,056,487
Members
444,869
Latest member
tulo spont

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back