Hi,
I'm fairly new to excel and would really appreciate some help.
I am trying to set up a spreadsheet that allows me to find multiple matches based on multiple cell values. For instance I have Name, Department, Salary, Employee ID, Year hired etc. I want to be able to call specific info (possibly through vlookup) from the employee ID and view other employees that match some of the information (year hired, salary, year hired). I know I could use a filter however it can be time consuming as it is a large database.
Any ideas?
Bookmarks