CODEWITHSUNDEEP
google-sheetsgoogle-drive-api
andodé
andodé

Reputation: 23

Query a value from another sheet

I'm trying to extract the name of a project each time the name of an employee shows up in a given column. I set up a simple query like the following: 

=query(Sales!4:555, "select I where R='name'")

Now, if I want this query to take the employee name from another sheet (same file) in which are listed all the employees. I was thinking: 

=query(Sales!4:555, "select I where R='PMs!=$A$2'")

But it's not working this way.

How should I do so?

Upvotes: 1

Views: 200

Answers (1)

pnuts
pnuts

Reputation: 59450

Based on Query syntax using cell reference please try: 

=query(Sales!4:555, "select I where R = '"&PMs!$A$2&"'")

Upvotes: 1

Related Questions