Excel - LOOKUP Function Problem - Expert Solution

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
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
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.

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.