Hari101213
New Member
- Joined
- Jun 4, 2020
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
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
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