98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » V look up
V look up
Resolved · Low Priority · Version 2003
Tue 17 Feb 2009, 16:49Delegate Avtar said...
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
Wed 18 Feb 2009, 11:05Trainer Amanda said...
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.xlsTue 24 Feb 2009: Automatically marked as resolved.
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
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Customize the toolbar in Excel 2010You can create your own toolbar which contains your favourite or most used tools. This will make using Excel much more efficient. To do this, you need to click on View, then select Customize Quick access Toolbars and then select Customize. A list of tools will then appear on the screen of which you can add or remove them as you please. |
