Returning back a cell value

[Kaveh]

Hi,
I have this problem for a while.
I want to return back the value of specific cell by the help of 2 other cells. For example:
I have 5 in cell B5,
and I have b in cell c5 and 5 in cell d5.
Now I wonder how can I put the value of cell b5 in cell E5 by adding, joining the cells C5 and D5.
I want the value of B5 in E5 by the help of 2 cells namely C5 and D5. I couldn't find my way out. Thanks in advance for the solution.

 

[Peter_SSs]

Welcome to the MrExcel board!

You can use this formula, but be aware that INDIRECT is a volatile function so can slow your sheet if used a lot.

=INDIRECT(C5&D5)

 

[Kaveh]

Thank you very much for the fast reply.
Your given solution worked and was exactly the same thing I was looking for.

 

[Peter_SSs]

No problem. Glad to help.

 

[Rick Rothstein]

Welcome to the MrExcel board!

You can use this formula, but be aware that INDIRECT is a volatile function so can slow your sheet if used a lot.

=INDIRECT(C5&D5)

If the column is always Column Z or less, then this non-volatile formula could be used...

=INDEX($A$1:D5,D5,CODE(UPPER(C5))-64)

 

[Kaveh]

Thank you sir. Your suggestion worked and was a great help as well. I appreciate it.

 

[Peter_SSs]

If the column is always Column Z or less, then this non-volatile formula could be used...

=INDEX($A$1:D5,D5,CODE(UPPER(C5))-64)

I'm not sure how the OP is intending to use the formula but I would say this INDEX alternative is very problematic.
- Even with the restriction to column Z your formula would have to INDEX A:Z, not A1:D5. That would give the formula over 26 million dependant cells so it may not be much less volatile at all.
- The two formulas don't do the same job. Generally cell references are used like that so that the formula points to the same address all the time. With the setup as per the example given, if a new column A is inserted, my formula will still point to (the new) B5 whereas yours will now be pointing to C5, even though the reference cells will still be indicating B5. So, generally any insertion/deletion of columns or rows could likely mean that the INDEX formula is not returning the value from the cell indicated by the two reference cells.