If then then formula help

[cassandralcoleman]

Need a formula for the following.

IF sheet 1 cell a2 = Y(text)

THEN sheet 2 cell a2 = sheet 1 cell b2 (number)


tried various things completely stuck on this one.

Thanks

[Special-K]

Try

in Sheet2!A2
=IF(Sheet1!A2="Y",Sheet1!B2,"")

[cassandralcoleman]

YAY that worked. now how do I get it to only recognize the cells that have "Y" in then with out leaving blank cells for those that do not containe "Y"?

Thank you again so much!!!

[Special-K]

If Sheet1!A2 is not "Y" what do you want Sheet2!A2 to contain?

[cassandralcoleman]

I would want sheet2!a2 to contain the next cell on sheet 1 that =Y

Thanks again

[Special-K]

Prob best post your workbook

[cassandralcoleman]

How do I do that?

[cassandralcoleman]

I hope this works

[cassandralcoleman]

Special K

I deleted my spreadsheet as I do not want tons of other people accessing it. If you did not get it let me know.

Thanks