Question about Microsoft Windows Vista Home Basic for PC
I want a formula that when a number is placed in a column (say e) on one sheet, it will pick up the text from another column in the same line (say b), and transfer that text into a selected column/line in a different sheet, but within then same book!!
The formula will check sheet1 cell e1, if there is any number or text put in there, the value of Sheet1 cell b1 will be copied to sheet2 cell a1. If you don't supply any number or text in sheet1 cell e1, there's nothing will appeared in sheet2 cell a1.
If you want some text will display when there's no value in sheet1 cell e1 just change the formula like this:
You can modify it as your like. Just copy the formula to another row in sheet2 column a.
P.S.: If this information was helpful, please rate this solution.
Posted on Mar 13, 2009
A 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
The service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
Nov 05, 2009 | Microsoft Office Excel 2003 for PC
Mar 20, 2009 | Oracle Database Enterprise Named User Plus
Feb 17, 2009 | Microsoft Excel for PC
Feb 11, 2009 | Microsoft Excel for PC
Dec 10, 2008 | Microsoft Excel for PC
Jul 08, 2008 | Microsoft Computers & Internet
Feb 03, 2008 | Microsoft Excel for PC
Dec 19, 2007 | Computers & Internet
Dec 04, 2007 | Microsoft Excel for PC
131 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: