Hey Art, I'm kind of confused. Is this a value that I would put in one cell
or in multiple?

I'm a newbie at excel. Thanks!

PS: The name of the first sheet is "Master List".

"art" wrote:

Try this:

=IF(Sheet1!G1="y",Sheet1!G12,"")


Let me know if this helps.



"Adam" wrote:

Hey everyone, I think this is an easy question, but I can't figure it out...

Here goes nothing:

There are two tabs.

The first tab is a master list with eight columns.
The seventh column, "G", will have values of "Y" or "N"

The second tab would only return the rows from the first tab that have a "Y"
for the value in column "G".

Any ideas? I'm stumped...