Hello, how can i get the slice of my googlesheet base on another sheet by useremail()?

[Moicz]

i need to get the slice of this..  data[name].. by another sheet of Ref_sdo[name] with email..  by useremail()? i need to show the user their own data by their own email address

sheet 1 = data[name]

sheet 2 = Ref_sdo[name] and another "column [email]"

to show the user its own data by useremail?? please help me!

[Aurelien · Accepted solution]

Hi @Moicz 

You may want to have a look to this expression:

LOOKUP() 

It could be: 

[name]=LOOKUP(USEREMAIL(),"Ref_sdo", "Email","Name")

[Moicz]

thank you so much!!!