How do I lookup a value from one sheet and put the value into another sheet using VLOOKUP?

What is the proper formula using VLOOKUP to place a value in cell F2 in Completed Surveys tab using the data from Total Surveyed tab?  There will be many more rows added to this spreadsheet each day and I'm looking for a formula I can use and copy down each row.  The item it needs to match is Number of each sheet then pull in the data from column 7 of sheet Total Surveyed into Job Name column in Completed Survey sheet.

Thanks for the help.

Bill
Test-v1.xlsm
cowboywmAsked:
Who is Participating?
 
Wayne Taylor (webtubbs)Commented:
Use this formula in cell F2 and copy down as needed.

=VLOOKUP(A2, 'Total Surveyed'!B:G, 6, FALSE))
0
 
Saurabh Singh TeotiaCommented:
I will use following formula in F2..

=VLOOKUP([Number],Total_Surveyed[[Number]:[Manager Line of Business Name]],6,0)

And this formula in G2..

=VLOOKUP([Number],Total_Surveyed[[Number]:[Manager Line of Business Name]],4,0)

Saurabh...
0
 
Saurabh Singh TeotiaCommented:
Your workbook attached...

Saurabh...
Test-v1.xlsm
0
 
Russ SuterCommented:
See attached
Test-v1.xlsm
0
 
cowboywmAuthor Commented:
This solution worked the best but I did have to change the FALSE to TRUE to get a match for each line even though I did not see any text variation in the larger file.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.