Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel functions
I want to use the following IF ... THEN.
If any cell in column D contains x then put y in the same row in column G and If any cell in column D contains a then put b in the same row in column H Can this be done? |
#2
|
|||
|
|||
Quote:
In G1 put =IF(D1="X","Y","") and in H1 put =IF(D1="A","B","")then copy both formulas down as needed. |
#3
|
|||
|
|||
Thank you. I had hoped there would be one instruction to analyse the column.
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel functions
On Monday, April 9, 2012 7:25:39 AM UTC-5, Matthew Williamson wrote:
I want to use the following IF ... THEN. If any cell in column D contains x then put y in the same row in column G and If any cell in column D contains a then put b in the same row in column H Can this be done? -- Matthew Williamson Or use a worksheet_change event macro to make it automatic without any formulas. Right click sheet tabview codeinsert Private Sub Worksheet_Change(ByVal Target As Range) If Target.Count 1 Or Target.Column < 4 Then Exit Sub If UCase(Target) = "X" Then Target.Offset(, 3) = "Y" If UCase(Target) = "A" Then Target.Offset(, 4) = "B" End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Any way to use "standard" Excel functions inside VBA functions | Excel Programming | |||
How to convert cell formula functions to code functions | Excel Discussion (Misc queries) | |||
efficiency: database functions vs. math functions vs. array formula | Excel Discussion (Misc queries) | |||
Conversion from Spreadsheet Toolkit functions (ESSV....) to EssBase API functions | Excel Programming | |||
excel functions and User defined functions | Excel Programming |