I would like to create a formula for this equation:
If B1 is marked with an "x", then insert the text from B2.
OpenOffice.org Forum :: Help on linking cells with sheets and ::
9 posts - 3 authors - Last post: Jan 2I can determine a formula if I know what governs it. . Then i used the VLOOKUP combined with the MATCH functionexactly like h1h suggested
http://www.oooforum.org/forum/viewtopic.phtml?t=67299HOME |
Another addition to my problem is that I would like this formula on a separate worksheet than the one that the x and text is on.
Thanks for your help!! :nut:
I would like to create a formula for this equation:
If B1 is marked with an "x", then insert the text from B2.
Another addition to my problem is that I would like this formula on a separate worksheet than the one that the x and text is on.
Thanks for your help!! :nut:
=IF(SheetName!B1="X",SheetName!B2,"")
Substitute SheetName with your sheet name. If your sheet name consist of two or more words, enclose in a single quote.
=IF('Sheet Name'!B1="X",'Sheet Name'!B2,"")
Thank you maxflia10! It worked!! The thing I had wrong in the formula was the last quotation marks. Why do you need those if you have 'SheetName'!B2 there?
 Traditional University or MLM University? You Choose
 15 Questions to Ask Your Software Vendor
|
Solved: Need help with IF THEN formula