Formula to search for exact match and to return specific value in a another cell?

Hello,

I have a column "A" (random numbers only) which is representing the sales done.

I have another column "H" , which I will fill manually only with "1" or "0".

I want a formula, which is going to search all the "1" in the column H and if it finds a match to take the same value from the column "A" and to put it in a column "D".

For example I have cells H2, H4 and H7 filled will "1" only, all the rest is "0"
In that case I should have cells D2, D4 and D7 filled only, with the same values as in cells A2, A4 and A7.

Attaching the picture of how it should look like.

example.jpg


Any ideas on how to do that?

place this in D2 =if(H2=1, A2,"") and copy down

Try this:

=IF(H2=1,A2,"")

if you are using Bulgarian regional settings:

=IF(H2=1;A2;"")

You're welcome.

---

If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.