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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Wayne Taylor (webtubbs)Commented:
Use this formula in cell F2 and copy down as needed.

=VLOOKUP(A2, 'Total Surveyed'!B:G, 6, FALSE))
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.