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

v look up

ResolvedVersion 2016

Duncan has attended:
Excel Intermediate course
Excel Advanced course

V Look Up

I have 2 spreadsheets and I want to use a vlookup to take information from one column in one spreadsheet and populate that data in another spreadsheet so it consolidates into one document

I have an employee ID as the common value in both documents. Can you provide me with instructions about how I do that?

Thanks

RE: V Look Up

Hi Duncan

Thanks for your question.

The structure of the VLOOKUP function is:

=VLOOKUP(lookup value,lookup table,column index number,range lookup)

Column index number is the column you want to return your information from - you need to count columns from left to right in your lookup table 1,2,3 until you get to the column you want to return the info from.

Range lookup specifies whether it is an approximate or exact VLOOKUP.

Try using the formulas below (you will need to substitute some parts with your own references):
Column A - list of employee IDS

Column B =VLOOKUP(A1,employeetable1,2,0) -- where column 2 refers to eg employee names in your employeetable1

Column C =VLOOKUP(A1,employeetable2,3,0) -- where column 3 refers to eg employee locations in your employeetable2

Let me know if you need any more help.

Kind Regards,

Sarah
Excel Trainer

Wed 13 Jun 2018: Automatically marked as resolved.

Excel tip:

Status Bar Functions

When using the SUM, MIN, MAX, AVERAGE and COUNT functions, the result of such calculations are displayed in the worksheet.

However, if a range of cells, containing numbers, is highlighted, and then a right-mouse click is performed at the bottom right side of the status bar, then the result of those functions will be displayed.

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.09 secs.