Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

hey I'm doing a basic course on excel at university, I have been told I have to connect a customer name to an id number, for example, if I type customer id '1' they want this customers name to replace the '1'. thankyou
Solved by V. J. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
User 23/05/2018 - 01:28
how do I make it so when I type a '1' tom comes up?
Excelchat Expert 23/05/2018 - 01:28
Hi
User 23/05/2018 - 01:28
hello
Excelchat Expert 23/05/2018 - 01:28
Welcome to Got it Pro
User 23/05/2018 - 01:28
thankyou
Excelchat Expert 23/05/2018 - 01:28
Can you explain your requirement so that i can help yhou better
User 23/05/2018 - 01:29
in the excel sheet to the right I would like to be able to type a '1' and toms details comes up
User 23/05/2018 - 01:29
or replaces the '1'
Excelchat Expert 23/05/2018 - 01:29
Now type 1 in column A
User 23/05/2018 - 01:30
am I able to make it replace the '1' or can I only get it to go in the next column?
Excelchat Expert 23/05/2018 - 01:30
you can get in the next column
User 23/05/2018 - 01:31
ok how did you do that?
Excelchat Expert 23/05/2018 - 01:31
I column H and I, i fixed the values what you want against each number
Excelchat Expert 23/05/2018 - 01:32
Then i column B i used a lookup function to get a matching value from column H and I against column A
Excelchat Expert 23/05/2018 - 01:32
1 tom 2 james 3 anna 4 dane 5 ellen 6 eric
Excelchat Expert 23/05/2018 - 01:32
=iferror(VLOOKUP(A4,\$H\$2:\$I\$8,2,0),"")
Excelchat Expert 23/05/2018 - 01:32
This si the formula used
Excelchat Expert 23/05/2018 - 01:32
Hope this helps you out
User 23/05/2018 - 01:32
ok thankyou I should be alright from here
Excelchat Expert 23/05/2018 - 01:33
Cool
Excelchat Expert 23/05/2018 - 01:33
Please do give good rating and reviews
Excelchat Expert 23/05/2018 - 01:33
It really helps
Excelchat Expert 23/05/2018 - 01:33
Have a great day
User 23/05/2018 - 01:34
yo too
Excelchat Expert 23/05/2018 - 01:34
You can end the session to provide your ratings

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.