Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
bioyyy
 
Posts: n/a
Default Text shown up in other cells everytime a text is entered in 1 cell

Hello there,

I have a question, Let me show the table first, so make it easy to understand:

Col A Col B Col C Col D
P9-A-1 test-1 1 blue
P9-A-2 test-2 1 green

--
--
P9-B-1 test-1 1 blue

Here is my question: I'd like to see the value or text in Col A, C, D shown
up (row 1), everytime I type or enter a text in Col B row 1 (B1). If there is
NO text typed in B1, then I'd like to have an empty cell in A1, C1, and D1.
So, it must be a condition something....in other words, if there is something
in Col B, show value or text in Col A, C, and D. IF not, just return as an
empty cells in those cols. Thanks for your help.


  #2   Report Post  
CLR
 
Posts: n/a
Default

It depends on how many options you have for column B......if only a few, you
can use "IF" formulas is Columns A,C, and D.......if many, the VLOOKUP
feature should do the job for you.......

Vaya con Dios,
Chuck, CABGx3



"bioyyy" wrote:

Hello there,

I have a question, Let me show the table first, so make it easy to understand:

Col A Col B Col C Col D
P9-A-1 test-1 1 blue
P9-A-2 test-2 1 green

--
--
P9-B-1 test-1 1 blue

Here is my question: I'd like to see the value or text in Col A, C, D shown
up (row 1), everytime I type or enter a text in Col B row 1 (B1). If there is
NO text typed in B1, then I'd like to have an empty cell in A1, C1, and D1.
So, it must be a condition something....in other words, if there is something
in Col B, show value or text in Col A, C, and D. IF not, just return as an
empty cells in those cols. Thanks for your help.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Not all pasted text appears in cells cjswift Excel Discussion (Misc queries) 1 August 8th 05 03:43 PM
Macro or Formula to remove Text from Cells smck Excel Worksheet Functions 6 May 11th 05 03:22 AM
Combining & formatting cells with text - Excel 2002 Bob Excel Discussion (Misc queries) 4 March 4th 05 11:35 PM
counting text cells Debbie Excel Worksheet Functions 4 February 8th 05 10:00 PM
How do I get merged cells to display all text. Excel problem Excel Discussion (Misc queries) 2 November 30th 04 05:29 AM


All times are GMT +1. The time now is 12:48 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"