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...
The names in the first three tabs are just a short name, the formula for each cell needs to be written to reflect what it is looking for in tab 4, the raw data.
The individuals names can be amended to include middle names also.
The names should be identical, and the competence names too.
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.
