Hi everyone,
I'm looking for a little bit of help on something that is probably very basic for most of you, and I can't seem to be able to figure out how to approach this.
I use vlookup frequently, but always just to bring one column from another spreadsheet to the master one where both spreadsheets have one reference point (a ticket number as I work in a tech support organisation).
We have employees with "skills" listed on a spreadsheet:
for example:
Name Expertise John French John English Michael German Sandra Spanish Sandra French
When we receive a new ticket, it gets a skills associated and then an employee would work on it (he/she doesn't have to be an expert on it). The exercise here is to add a new column is the ticket spreadsheet and see if there is a skill match between the employee's skills and the ticket skill.
Ticket Name Expertise of the ticket Match? 1 John English Yes 2 Michael English No 3 Sandra French Yes 4 John Spanish No
I'm trying to define a formula for my new match column...Any idea?
Thanks in advance,
Yann
Bookmarks