Question description:
This user has given permission to use the problem statement for this
blog.
I need a formula to do a lookup from one text list and deliver a text result
Solved by O. J. in 8 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
27/06/2018 - 12:30
Hi
User
27/06/2018 - 12:30
Hi
Excelchat Expert
27/06/2018 - 12:30
Welcome to Got it Pro
User
27/06/2018 - 12:30
Thanks. I'm hoping you can solve my problem
Excelchat Expert
27/06/2018 - 12:30
Can you please share your excel sheet and question
Excelchat Expert
27/06/2018 - 12:30
Yes. Please
User
27/06/2018 - 12:31
I can't it has confidential info
User
27/06/2018 - 12:31
I can make something up
Excelchat Expert
27/06/2018 - 12:31
ok. please create a dummy sheet
User
27/06/2018 - 12:32
I have these two sheets
Excelchat Expert
27/06/2018 - 12:32
Ok.
User
27/06/2018 - 12:33
I want to add a column to sheet 2 that matched the name from sheet 1
User
27/06/2018 - 12:33
So I want to have column C in sheet 2 say Debra
Excelchat Expert
27/06/2018 - 12:33
Please check the result in Sheet 2
Excelchat Expert
27/06/2018 - 12:33
Column C.. Is it fine?
User
27/06/2018 - 12:33
My vlookup is returning a ref error
Excelchat Expert
27/06/2018 - 12:34
#Ref error means you have selected only two columns in the vlookup function but you are expecting 3rd column result
Excelchat Expert
27/06/2018 - 12:35
Table array : A: B only two column If i give 3 give Ref error
User
27/06/2018 - 12:36
=VLOOKUP(A2,Sheet2!$A$2:$B$88,Sheet2!$B$2:$B$88,TRUE)
Excelchat Expert
27/06/2018 - 12:36
Yes.... First two is correct
Excelchat Expert
27/06/2018 - 12:36
Sheet2!$B$2:$B$88
User
27/06/2018 - 12:36
So this is wrong? I'm telling it to look at the specific range
Excelchat Expert
27/06/2018 - 12:36
Please change this "2"
Excelchat Expert
27/06/2018 - 12:37
Yes....Vlookup (A2, Specific Range, Col_index number,0)
User
27/06/2018 - 12:37
I see! That worked. I didn't understand that it had to be a column ref only
User
27/06/2018 - 12:38
Thanks!
Excelchat Expert
27/06/2018 - 12:38
Yes.. It should be column Ref number
Excelchat Expert
27/06/2018 - 12:38
your welcome :)
Excelchat Expert
27/06/2018 - 12:38
Request you to provide valuable feedback and end the session
User
27/06/2018 - 12:38
Ok that was all. You were awesome! Keep up the good work!
Excelchat Expert
27/06/2018 - 12:38
Please end the session to support the new user...
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.
