Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,479 questions
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
I have an Excel spread sheet with 3 sheets (Employee, Jobs, Hours)
Employee sheet got the following columns
SID, EmpID, First Name, Last Name
Jobs sheet columns
JobID, EmpID, JobName
Hours sheet columns
Empid, FirstName, LastName, WorkDate, JobID, JobName
I am no expert with this. But when I read about VLookUp, you must have the search column as the first in each sheet and it cannot search for 2 columns.
Would like to know whether there is any other way that this could be done.