Hi guys, I am trying to find out how to return a value of a cell if another cell is filled, if you could help me I really appreciate e.g - I will try and build the cenario

What I am trying to do is - A1 is empty, but if A1 is filled with the word SOLD than I would like A5 to be the value of A2 . Does that make sense to anyone of you who could help? Below is what I would like to do.

A1 A2 A3 A4 A5

empty 2 x y 0A1 A2 A3 A4 A5

SOLD 2 x y 2

Thank you

First, a posting tip... Please click on the

bluesentence at the end of this post and read the instructions on how to post data in this forum. Following those instructions when posting data will make it much easier for us to understand the layout of your spreadsheet.As for your question, you should review the Excel Help file for the IF function. Your question appears to be a fairly straightforward use of a basic IF statement.

You should read the Help file so that you understand the following suggestion and can adapt it to other situations.

Try this in A5:

=IF(A1="SOLD", A2, 0)

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Ask Your Question

Weekly Poll

How long do you think until flying cars or taxis are common?

Discuss in The Lounge

Poll History