Assistance with VLookup

[DoggoS]

Hi there,

I have 2 sheets containing various employee data - one sheet named 'User data' contains the Full Name (in column A), and another sheet named 'Employee with Samsung' contains 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 B) within the 'User Data' sheet.
I hope that makes sense...
Grateful for any assistance - thank you in advance

 

[Automatrix]

Since you have Office 365, you should use the newer (and much better) XLOOKUP instead.

If you can organise the data into two tables called UserData and EmployeeWithSamsung, you can use

=XLOOKUP([@[Full Name]],EmployeeWithSamsung[Full Name],EmployeeWithSamsung[Device Details],"")

 

[etaf]

=VLOOKUP('User data'!A2,'Employee with Samsung'!$A$2:$B$1000,2,FALSE)

copy down
change 1000 to how ever many rows you need to over

also if name is not found you get an error , so to stop the error code use

=IFERROR(VLOOKUP('User data'!A2,'Employee with Samsung'!$A$2:$B$1000,2,FALSE),"")

 

[DoggoS]

=VLOOKUP('User data'!A2,'Employee with Samsung'!$A$2:$B$1000,2,FALSE)

copy down
change 1000 to how ever many rows you need to over

also if name is not found you get an error , so to stop the error code use

=IFERROR(VLOOKUP('User data'!A2,'Employee with Samsung'!$A$2:$B$1000,2,FALSE),"")

Thank you so much, this worked a treat

 

[etaf]

you are welcome