Complex formula possibly Index & Match

[DoggoS]

Hi there,

I have 2 sheets containing various employee data - one sheet named 'Mob Data' contains the Employee Full Name (in column A) and the other sheet named 'Master data' contains Employee Full Name (in column A) along with Employee's function (in column F of this sheet).
I need a formula to look up the Employee Name from 'Mob Data' sheet and match it to the Employee Full Name from 'Master data' sheet and if it finds it to then retrieve the Function from this sheet and populate it into the Function column (column B) within the 'Mob Data' sheet.
I hope that makes sense...
Grateful for any assistance - thank you in advance

 

[DoggoS]

Try

=IF(ISNUMBER(MATCH(B2,'Base Report'!B:B,0)),"N","")

This worked - thank you so much

 

[Sufiyan97]

You're welcome!

Your original question was answered by @AlanY , so please keep your marked solution on post #3, and for future posts if the question is different please post it as a new thread.

 

[Joe4]

Your original question was answered by @AlanY , so please keep your marked solution on post #3, and for future posts if the question is different please post it as a new thread.

That is absolutely correct. The marked solution should be the solution to the original question. I have set it back.

It is another reason why when you have a new question, it is usually best to start a new thread. You can always add links back to old questions, if it is pertinent to the new question.

 

[DoggoS]

Try

=IF(ISNUMBER(MATCH(B2,'Base Report'!B:B,0)),"N","")

Thank you so much, this worked