How to use vlookup function?

Asked By charles garcia 10 points N/A Posted on - 04/12/2012

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.

• Status: Open
• Question Views: 1221
• Answer Count: 3
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by fahad.mughal

Go To Solution

Best Answer

Best Answer

Answered By fahad.mughal 0 points N/A #102395

How to use vlookup function?

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.

 

About fahad.mughal

Questions
0

Answers
1

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 04/13/2012
• Question Category: MS Excel

Answered By Tech Answers 0 points N/A #102396

How to use vlookup function?

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.

About Tech Answers

Questions
1

Answers
1

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 04/15/2012
• Question Category: MS Excel

Answered By charles garcia 10 points N/A #102397

How to use vlookup function?

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.

About charles garcia

Questions
22

Answers
7

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 04/19/2012
• Question Category: MS Excel