Thanks, I finally got it to work. I appreciate the help.

"Ardus Petus" wrote:

Since your Worksheet name contains spaces, you must surround it with '
(single quotes)

IF('Departure Sign-up Sheet'!O2="YES",'Departure Sign-up Sheet'!O2")

HTH
--
AP

"Christy" a écrit dans le message de
...
Okay, I tired and it didn't work. Me thinks I'm a trifle slow. Here's what
I
entered:

IF(Departure Sign-up Sheet!O2="YES",'"Departure Sign-up Sheet!O2")

I am putting this is the hotel sheet. I want the information from the
Departure Sign-up Sheet to populate in the hotel sheet. Please let me know
what I'm doing wrong.

Thanks,
Christy

"Ardus Petus" wrote:

Assuming your source data is in Sheet1,

In "another sheet", enter formula:
=IF(condition,Sheet1!A1;somevalue)
where you replace condition by the appropriate formula, eg:
=IF(Sheet1!A10;Sheet1!A1;"")

HTH
--
AP

"Christy" a écrit dans le message de
...
I want to have a column that will populate another column in another
sheet
only IF a criteria is met. Is that possible?