Search : in
By :

If Function question

Last answer on Nov 5, 2009 11:24:07 am GMT Captain M, on Nov 4, 2009 2:19:05 pm GMT 
 Report this message to moderators

Hello,
I am trying to get 3 cells to populate with different data by only choosing data from only one cell. If a1 = xxx then cell a2 will = yyy cell a3 will = zzz, this is set data that has to appear each time this combination is used a1 is xxx all the others will always be the same data, if this make any sense could you help me get these cells to populate. Many thanks

Configuration: Windows XP Internet Explorer 8.0

Best answers for « If Function question » in :
Using excel if function with data validation Show
REMOVING " FALSE " VALUE IN "IF&quo Show
[Excel 2003] - IF Function using Dates & Text Show [Excel 2003] - IF Function using Dates & Text Issue Solution Note Issue I'm trying to write a function for a cell which refers to a date in another cell - which if it is between 01/01/1994 and 31/12/1995 the cell will read U16, but...
Colouring cells on conditions ShowColouring cells on conditions There are many pratical functions under Excel which is not commonly used. Example: If you wish a cell automatically turns red (or other formatting border, frame etc) under one condition: a result, a...
[VBA] Detecting changes in cell Show[VBA] Detecting changes in cell The Event Change feature of a sheet will detects the change in the active cell but it gives no information about the content. The example given below will help you to find out if the cell was changed,...
The Fn key is locked ShowThe Fn key is locked If you're writing numbers instead of letters when you press the keyboard of your laptop and you must hold down the Function key (Fn) to write normally. This is due to the fact that the digital lock is activated. To...
Download Business Functions Show
Download Envisioneer Express ShowIf you plan to construct a home, but you do not succeed in imagining final outcome, then this program will serve you and answer your wait. Envisioneer express is a free program of modelling in 3D, notably plans of home. It understands functions of...
Spreadsheets - Conditional expressions ShowWhat is a Conditional Structure? Conditional structures are instructions that allow to test if a condition is true or not. Conditional structures may be associated together. To successfully execute these tests using logical functions, spreadsheets...
Spreadsheets - Logic Functions ShowThe Concept of a Function Spreadsheets generally have a large number of integrated functions for processing data. There are hundreds, categorised as follows: Arithmetic functions that offer basic tools to process numerical data Statistical...
Spreadsheet - Functions ShowThe Concept of a Function Spreadsheets generally have a large number of integrated functions for processing data. There are hundreds, categorised as follows: Arithmetic functions that offer basic tools to process numerical data Statistical...
Ask your question Reply

1

 venkat1926, on Nov 5, 2009 11:24:07 am GMT

Did not understand. I am rephrasing your question
In column A wherever XXx is entered then in the column B of the same row will be yyy and in column C of same row will be zzz.
if this understanding is correct then follow these instruction
right click the sheet tab and click view code
in the resuting window copy paste this EVENT CODE" 

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column <> 1 Then Exit Sub
If Target = "xxx" Then
Cells(Target.Row, "b") = "yyy"
Cells(Target.Row, "c") = "zzz"
End If
End Sub


Now inthe sheet in column type some entry other than xxx see what happens
again in some other cell in column A enter xxx then see what happens.

if this is ok confirm

   
Reply to venkat1926
Ask your question Reply
They need your help