Forum Discussion
Multiple Formula In A Single Cell
I'm facing a problem if you could find its solution. In cell A1 7650 In cell B1 =À1*20% (Value in cell B1 = 1530) In Cell C1 =B1*30% (Value in cell C1 = 459) In cell D1 =Sum(B1+C1) (Va...
The first formula it will show the row number of the value selected from column B
The 2nd formula it will show the row number of the value selected from column C
I want to combine these two formulae or more in a single cell to show the value selected either from column B or C or etc.
The 2nd formula it will show the row number of the value selected from column C
I want to combine these two formulae or more in a single cell to show the value selected either from column B or C or etc.
- Hi Hans,
Thank you for your quick response, it is working but when I am adding formula like the one below because I am having 21 columns, it is giving me message box saying, "you entered too few arguments for this function".
MATCH(V15,D2:D501,0)Let's say you want to look at C2:U501. Use the following formula. If you don't have Microsoft 365 or Office 2021, confirm the formula by pressing Ctrl+Shift+Enter.
=IFERROR(MATCH(V15,INDEX(C2:U501,0,MIN(IF(C2:U501=V15,COLUMN(C2:U2)-COLUMN(C2)+1))),0),"")
- Hi Hans,
That was amazing it is working alright, thank you very much!
Please can you do the formula vice versa now I need to find the column.