William C Johnson
asked on
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
Thanks for the help.
Bill
Test-v1.xlsm
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
See attached
Test-v1.xlsm
Test-v1.xlsm
ASKER
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.
=VLOOKUP([Number],Total_Su
And this formula in G2..
=VLOOKUP([Number],Total_Su
Saurabh...