Assistance with Vlookup

[DoggoS]

Hi there,

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

 

[Marcílio_Lobão]

DoggoS, good morning.

Try to use:

Sheet: Data to Check

B2 --> Formula
B2 =IFERROR(VLOOKUP(A2, 'Master Data New Connections'!$A$2:$B$11, 2, FALSE),"---- Not Found ----")

Please, tell us if it worked for you.

Hope it helps.

 

[DoggoS]

=IFERROR(VLOOKUP(A2, 'Master Data New Connections'!$A$2:$B$11, 2, FALSE),"---- Not Found ----")

Thank you so much - that done the trick

 

[Marcílio_Lobão]

DoggoS,

Thanks for the feedback.

I'm happy to have helped you.

Have a great weekend.