Assistance with VLookup Formula

[DoggoS]

Hi there,

I have 3 sheets containing various employee data - one sheet named 'User data' contains the Full Name (in column A), another sheet named 'Master Data' contains Full Name (in column A) and final sheet named named 'Employee with Samsung' contains Employee Full Name (in column A) along with 'Device Details' (in column B of this sheet).
I need a formula to look up the Full Name from 'User Data' sheet and match it to the Full Name from 'Employee with Samsung' sheet and if it finds it to then retrieve the 'Device Details' (in column B) from this sheet and populate it into the Device Details (column D) within the 'User Data' sheet.
I hope that makes sense...
Grateful for any assistance - thank you in advance

 

[etaf]

=index('Employee with Samsung'!$B$2:$B$1000, match(A2,'Employee with Samsung'!$A$2:$A$1000,0))

you could also do with a vlookup
=Vlookup(A2, 'Employee with Samsung'!$A$2:$B$1000,2,false)

not sure where master data sheet comes in
as all sheets have full name in column A

if the name is not found you get an N/A error - you can use IFERROR() to change that to another massage

 

[DoggoS]

=Vlookup(A2, 'Employee with Samsung'!$A$2:$B$1000,2,false)

Amazing thank you Etaf this done the trick

 

[etaf]

you are welcome
meant to have mentioned - change 1000 to however many rows cover your data

 

[I_know_nuffin]

=VLOOKUP(A2,'Employee with Samsung'!A:B,2,FALSE)
will add the device details and a #N/A if no match


=IFERROR(VLOOKUP(A2,'Employee with Samsung'!A:B,2,FALSE),"")
will add the Device details and a blank if no match