Question description:
This user has given permission to use the problem statement for this
blog.
I need a formula to select a cell value based on what I enter in another cell. For instance, if have a long list, and I want to recall "A34891", I want to enter "A34891" in one cell, and it is used as a search for cell A34891, and displays its information.
Solved by G. F. in 6 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
02/07/2018 - 09:17
Hi
User
02/07/2018 - 09:17
hi
Excelchat Expert
02/07/2018 - 09:17
Welcome to Got It Pro.
Excelchat Expert
02/07/2018 - 09:18
I have referred the requirement. It can be achieved using Indirect function.
Excelchat Expert
02/07/2018 - 09:18
=INDIRECT(C1)
Excelchat Expert
02/07/2018 - 09:18
Please check the sample.
Excelchat Expert
02/07/2018 - 09:18
I have entered A1 in C1 cell as variable.
Excelchat Expert
02/07/2018 - 09:19
And formula in D1 is linked to C1. So, it gets value from the variable mentioned in the C1 cell.
Excelchat Expert
02/07/2018 - 09:20
Hope, the requirement is met?
User
02/07/2018 - 09:20
well, i feel stupid. i tried this exact function all wrong
Excelchat Expert
02/07/2018 - 09:21
Hope, it is working well.
User
02/07/2018 - 09:21
based on what I wrote, yes. Can I ask another question, while I have you? I have a more advanced use of this in mind
Excelchat Expert
02/07/2018 - 09:22
Hi, As per the policy, we are allowed to answer one question per session. If it is small, i can try help you.
User
02/07/2018 - 09:22
i don't think it's small, at all. thanks anyway, though!
Excelchat Expert
02/07/2018 - 09:23
Please do visit Got It Pro. We have 24 * 7 problem solving facility. You can visit any time.
Excelchat Expert
02/07/2018 - 09:23
Have wonderful day ahead. Please end the session and leave valuable feedback.
User
02/07/2018 - 09:23
thanks! you too
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.