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.