excel vlookup with multiple criteria
i have two spreadsheets
master - contains all the data for all the benefit plans. from this spreadsheet i need to lookup the employee first by the ss# column and then i need to find a match to a specific benefit_plan (i.e. medical, dental)
the second spreadsheet also has the ss# for the employee, but i need to lookup in the master to see whether that specific employee actually has medical or not.
can you use two columns to define the employee and then return the needed item as true or false?
i am enclosing two sample files.
|