Excel - IF Function Problem - Expert Solution

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
User 02/07/2018 - 09:17
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
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.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc