Using IFS formula to reference to different cells but fetch value coming out the same

[Hari101213]

Hi guys,

I have an IFS formula that is suppose to reference to multiple cells and fetch the corresponding figure
Problem is even thou my reference cells are difference the text in some of them are the same, so the formula fetches me the wrong corresponding figure
Here is a numerical example
IF A1 =A3, text in A3 is Apple display me C6
IF A1 = A4 text in A4 is also Apple display me C7

Current formula displays C6 for both options since the text in both of them is the same Apple

I want the IFS formula to fetch based on cell reference instead of the text in the cell. Is this possible? If i change one of the text to Apple1 instead of just apple everything works find but i am trying not to change the text in the cells.

Any work around for this?

Thank you for your kind help

 

[jasonb75]

In the event of multiple matches, the first one found will be returned. If both are the same, how do you determine which one should be used?

I suspect that you need to use a combination of IF AND and OR, but your logic is not making a lot of sense.

 

[Hari101213]

Hi thanks!

I will try using multiple conditions so that I just don't depend on that one cell with the same word. Will try later and see if it works

 

[Hari101213]

The difference is the cell reference number I was hoping excel will ignore the text since my condition is A1=A3 and not A1="Apple" but it does not ignore the text

 

[jasonb75]

A formula only looks at the value in the cell not the address of the cell. That will only work if you check each one individually with the highest priority first.

Using IFS, you could try swapping the order of the first 2 logical tests.