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
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
Try
in Sheet2!A2
=IF(Sheet1!A2="Y",Sheet1!B2,"")
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
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!!!
If Sheet1!A2 is not "Y" what do you want Sheet2!A2 to contain?
I would want sheet2!a2 to contain the next cell on sheet 1 that =Y
Thanks again
Prob best post your workbook
How do I do that?
I hope this works
Last edited by cassandralcoleman; 09-25-2012 at 05:37 PM.
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks