Thanks will,

This is close.

I have two sheets. One sheet (user with devices) contains the data
(multiple occurrences of a name with several devices) and the other (users)
is just the names. I need to lookup the name in (users) in the list in (user
with devices) and return if the user has registered a text device.

Thanks, Mark