VLOOKUP not matching values and putting values

2
votes

I am trying to use LOOKUP function for the following columns in one workbook: Sheet A contain ID and Sheet B has empID.

I am trying to compare both ID's i.e. ID from Sheet A and empID from Sheet B. If there is a match, I am putting the hourly rate in the column.

My VLOOKUP function looks like this:

=VLOOKUP(B2;test;emp!M2;FALSE)

Where test is : $A$2:$E$78

Please find the excel file in the dropbox folder link. Dropbox

1
excelexcel-formulavlookup

1 Answers

2
votes

The VLOOKUP function always looks up the lookup_value in the first column of the table_array and returns a value from a column to the left identified by a numerical col_index_num.

In Time_Spent!F2 as,

=VLOOKUP(B2; test1; 6; FALSE)

Note that your posted sample used a named range of test1, not test and test1 was =Employees!$A$2:$F$78, not =Employees!$A$2:$E$78. You cannot ask for the 6th column if you only supply 5.