Assistance with Vlookup

[DoggoS]

Hi there,

I have 2 sheets containing various employee data - one sheet named 'Samsung Replacement Master' contains the Employee Email Address (in column D) and the other sheet named 'A34 Registered Users' contains Employee Email Address (in column H).

I need a formula to look up the Employee Email Adddress from 'A34 Registered Users’ sheet and match it to the Employee Email Address from 'Samsung Replacement Master’ sheet and if it finds it to then put ‘Y’ into the ‘New Device Enrolled’ (Column I) within the 'Samsung Replacement Master’ sheet.
I hope that makes sense...
Grateful for any assistance - thank you in advance

 

[RobP]

Hi,

maybe something like this can help you if you paste into Col I and copy down. (assuming data started in D2 (row 2)

=IF(IFNA(VLOOKUP(D2,'A34 Registered Users'!H:H,1,FALSE),"")<>"",1,"")

Rgds
Rob

 

[Peter_SSs]

Or you could try this in cell I2 (no need to copy down, but check the range used in the formula to match your data in the Samsung sheet)

=IF(ISNUMBER(MATCH(D2:D20,'A34 Registered Users'!H:H,0)),"Y","")

For the future, to get better, faster and more tailored responses, I suggest that you investigate XL2BB for providing sample data & expected results to make it easier for helpers to understand just what you have & where it is and also what you want & where it is to be. If you have trouble with XL2BB review the "XL2BB Icons greyed out" link in the 'Known XL2BB issues' section near the top of the XL2BB Instructions page linked above.

 

[DoggoS]

Hi,

maybe something like this can help you if you paste into Col I and copy down. (assuming data started in D2 (row 2)

=IF(IFNA(VLOOKUP(D2,'A34 Registered Users'!H:H,1,FALSE),"")<>"",1,"")

Rgds
Rob

Hi Rob,

Thank you for this but unfortunately its retrieving incorrect data. Data starts from D4 (row 4).

 

[RobP]

try replacing D2 with D4 in the formula ?

Rob

 

[DoggoS]

Or you could try this in cell I2 (no need to copy down, but check the range used in the formula to match your data in the Samsung sheet)

=IF(ISNUMBER(MATCH(D2:D20,'A34 Registered Users'!H:H,0)),"Y","")

For the future, to get better, faster and more tailored responses, I suggest that you investigate XL2BB for providing sample data & expected results to make it easier for helpers to understand just what you have & where it is and also what you want & where it is to be. If you have trouble with XL2BB review the "XL2BB Icons greyed out" link in the 'Known XL2BB issues' section near the top of the XL2BB Instructions page linked above.

Thank you this done the trick

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.