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