Based on data in a different cell Copy data to another sheet.

[header454]

Hi
I am trying to use the IF function to copy a string of text in a cell on one sheet and place it in certain range of cells in a column in another sheet.
The IF function needs to determine which particular range of cell the text is copied to basted on the contents of another cell in sheet 1.
The cell in sheet 1 can have one of 3 different options selected from a drop down box.
Is what I am trying to do possible or am I asking too much, particularly as I don’t have a lot of experience

[FoxSeaLady]

Hi
Can you please upload a sample spreadsheet including the desired outcome. It will make understanding the problem a lot easier.
Cheers