If Cells Equals "1" Return Specific Cell, If not Return Nothing

Hi All,

Quick Question for everybody. I am trying to figure out a formula, just as my title suggested, it would be for: If a Cell Equals "1" Return Specific Cell, If it does not equal 1 Return Nothing. I have also attached a document of ideally how it would look.

Thanks in advance for any and all help!

Excel Question.xlsx

=IF(Cell=1,SpecificCell,"")

You don't actually state in your post which cell may, or may not, equal 1 or which specific cell to return if it does...

F2 = IF(C2 = 1, E2, C2)
pull down

Like that?

That will create the table as per example, but it doesn't really match what you're saying in your post.

Try this in F2 and filled down.

=IF(C2=1,E2,C2)