Lookup not returning any text

[Domearian]

Hi All, I am using Lookup("Tier 1 Text","Email List","Tier 1 Selected",Email) to return some text from dataset "Email List".

One randomly chosen value from this list ( ........The list of values of column 'Email' ........from rows of table 'Email List' ........where this condition is true: ((The value of column 'Tier 1 Selected') is equal to ("Tier 1 Text"))) Which is what I want.

The item Tier 1 Text has a value of "Tess" and the email List has an item called "Tess" with some text in the column Email.

I have that Expression in the "Formula" field so I thought when I save it, it would automatically add in the returned text. It's not returning anything. Any ideas?

[JuneCorpuz]

Hv

---

@Domearian wrote:

Lookup("Tier 1 Text","Email List","Tier 1 Selected",Email) 

---

Have you tried adding "" in the last parameter?

[Domearian]

Unfortunately that would not resolve the issue. I did however try a different expression which worked.

SELECT(Email List[Email], [Tier 1 Selected] = [Tier 1 Text])

This resolved the issue for myself. Sometimes it is worth while, taking a break from the screen and looking at a problem from a different perspective.