How to use vlookup function?

Asked By 10 points N/A Posted on -
qa-featured

How to use vlookup? Two databases I need to merge have an account number, which is the common factor between two files. I know that i can use vlookup function in excel, but don't know how.

SHARE
Best Answer by fahad.mughal
Best Answer
Best Answer
Answered By 0 points N/A #102395

How to use vlookup function?

qa-featured

It seems to me that you want to combine all the data you have into one master copy using the field "account number, correct?

If so, then create a master database with the field "account number" that you can use as a reference and place it in column A (the first column of the spreadsheet). 

Then use VLOOKUP to refer the database worksheets one at a time. 

After the 1st one, value the data you have found on the master then only use VLOOKUP on the columns that have missing data. 

Repeat this for each worksheet you need to reference.

For more details about how to apply Vlookup function you can have a look at this website.

 

Answered By 0 points N/A #102396

How to use vlookup function?

qa-featured

Here's a short video I created, that will take you through the steps in using Vlookup.

I have also uploaded the Excel file that I was using in the video tutorial, to help you understand the usage of Vlookup function.

Answered By 10 points N/A #102397

How to use vlookup function?

qa-featured

Techanswer!

Thanks.

That was a very helpful file. Yes combination of data between to different file. I want to reflect the data that was given on the other file to link it on the other. I've got your sample now and I was doing the format currently.

Thanks guys.

Related Questions