Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

v look up

ResolvedVersion 2003

Avtar has attended:
Excel Intermediate course

V look up

How can I merge two spreadsheets together? For eg one spreadsheet has NI and pay details, the other has NI and address. How can I put them together using v look up

RE: v look up

Hello Avtar

Thank you for your question and welcome to the forum.

The VLOOKUP function has 4 parts: 1. Lookup value. 2. Table array. 3. Column index number. 4. Range lookup.

Say you are using the vlookup to pull the person's address over to the sheet you have NI numbers and pay details on.

I would say in this example that the NI number would be your lookup value, as it is unique for each person.

For this to work, the NI number will need to be the first/leftmost column in the table with the address.

I've attached an example with a vlookup formula to demonstrate - the vlookup formula is in the yellow cells on the Pay sheet.

Kind regards
Amanda

Attached files...

vlookup.xls

Tue 24 Feb 2009: Automatically marked as resolved.

 

Training courses

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Excel tip:

Generate randon numbers

Some types of analysis require you to use randomly generated numbers. You can also use randomly generated numbers to quickly populate an Excel spreadsheet. There's an easy function you can use to do this automatically. Here are a few of the ways you can use it:

Type =RAND() in a cell to generate a number between 0 and 1.
Type =RAND()*100 to generate a number between 1 and 100.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.08 secs.