Hi Andrew and welcome to the forum.
Quote:
Originally Posted by adj1
Sorry I tried to lay this out as a table, but the forum text editor didn't like it
|
You can always attach an example workbook to the thread?
If I understand correctly, you're saying that if column A is "Green" then column C should pick up the value from column B, but if column A is "Blue" then column D should pick up the value from column B?
In cell C1 put this formula:
Code:
=IF(A1="Green",B1,0)
In cell D1 put this formula:
Code:
=IF(A1="Blue",B1,0)