98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Lookup function
Lookup function
Resolved · Low Priority · Version Standard
Helen has attended:
Excel Advanced course
Lookup function
How do I use lookup function to find data from another workbook?
RE: Lookup function
If you have two sets of data, highlight the second set and in the top left corner of the screen is the name box, in this box type 'Range1' and press the Enter key. Create a new column in your first set of data. In the first cell use the following formula:
=VLOOKUP(B1,Range1,1,FALSE)
This is essentially saying "take the value in B1 (B is the ID column of your first data set), and see if it occurs anywhere in Range1 (Range1 is the ID column of your second data set). If it does appear then it will return the ID (column 1, hence the 1 in the formula) and if it doesn't appear then it will return '#N/A'. The value of 1 will make it return the ID value. You can return any column in the range. For example, if you have column1 as the ID and column2 as the full name then you can change the formula as follows to return the second colum and therefore show the name:
=VLOOKUP(B1,Range1,2,FALSE)
Please see attached example
Attached files...
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:Sorting List SubtotalsIf you find that you would prefer to show the items in a subtotalled list in a different order, eg ascending rather than descending, you can sort your list. To sort a subtotalled list, hide the detail rows and then sort the subtotal rows. When you sort a subtotalled list, the hidden detail rows are automatically moved with the subtotal rows. |