Forum Discussion
QUery related Excel formula
Shouldn't you do your homework yourself?
Please help.
What have you tried?
I have tried the pivot table but problem is that i have to always change manually data then refresh the pivot table.
Can we do with the help of formula ?Please help..
a) You can use a COUNTIFS formula to check whether the first name/last name combination on Heads Data 1 occurs on Heads Data 2. If this formula returns 0, the employee is missing on the second sheet.
b) You can use an INDEX/MATCH formula to return the Job Description from Heads Data 1 on the Heads Data 2 sheet. You can then check whether it has changed.
c) You can also use INDEX/MATCH or VLOOKUP to return the surname (last name) corresponding to the first name from Heads Data 1 on the Heads Data 2 sheet. You can then check whether the surname has changed.