Forum Discussion
Execel Spread Sheet Help
Hoping someone can help me simplify the process for one of my work spreadsheets. Attached is a spreadsheet where I follow the training profiles for a nuber of people in my team. Tab 4 is the raw dat...
Ok, names are easily resolved, any ideas on formula to use??
In B2 on the first, second and third tab:
=XLOOKUP($A2&B$1, 'OBIEE 07 Feb 25'!$A$2:$A$1000&'OBIEE 07 Feb 25'!$B$2:$B$1000, 'OBIEE 07 Feb 25'!$D$2:$D$1000, "")
Fill down.
This will only work if the names in column A match exactly, and if the competences in row 1 of the first three sheets match the competences in column B of the OBIEE 07 feb 25 sheet exactly.
That's worked a treat, really appreciate your help with this:-)
