Using advanced IF formula

[Karavalkanov]

Hi All,

I am trying to apply an IF function (or whatever works) in order to populate a information from a column to another column.
For example, I have 3 columns- Column A (List of companies), Column (B)- unique code, Column (C)- Counterparty
I would like to populate column D with the content from one cell above from Column C if it relates to a specific company in column A.
I hope this makes sense as, having it manually it would take ages.

Thanks!

[63falcondude]

Hello and welcome to the forum.

I recommend uploading a small representative sample of your data along with the desired results based on that sample (which you can enter manually).

To upload an Excel workbook, follow these steps:
1) Click on "Go Advanced"
2) Click on "Manage Attachments"
3) Click on "Choose File"
4) Choose your file and click on "Open"
5) Click on "Upload"
6) Click on "Close this window"

[Karavalkanov]

Hi 63falcondude,

Thanks for pointing this out.
I think I have attached an example sheet.

Regards,

Georgi

[63falcondude]

I still don't understand what you are expecting as a result. Can you add in the desired results to your sample?

Since there are only 10 rows of data, this shouldn't take much time.

[Karavalkanov]

Hi 63falcondude,

Using the template I sent over, in D3 the formula should say: If "A2=Specific Company Name", then D2=C3.

Thanks,

[63falcondude]

There is no "Specific Company Name" anywhere in the workbook from post #3. Again, I'm not sure what you're expecting here.

I need to see column D from your sample filled in.

If you do not want to follow the request from post #4 then I'll move on.

[Karavalkanov]

Hi,

Apologies now it should be more clear. Thanks

[63falcondude]

You don't seem to understand what I am asking for.

I was expecting to see the desired results in cells D2:D11, not an explanation of the formula that you think is needed.

Simply looking at what you have put into D3 would give you this:
=IF(A2="Company A",C3,"")
but I'm confident that's not what you are looking for.

It's looking like I won't be able to help you here.

[MrShorty]

I would not call this an "advanced" IF() formula -- it seems rather basic =IF(A2="company A",C3,"not company A"). But it seems incomplete, too. What should the formula do in row 6 when A6 is "company A"? Should it retrieve the same bank name in C3, or should it retrieve the bank name in C7? Same question for row 10? Is the function only concerned with "company A" in column A, or does it need to make other choices when column A is "company B" and "company C"? I think we still need a better description of what you are really trying to do here.

[modytrane]

You need to explain your logic.
Fill in some more cells in column D.
What if A2 was "Company C"?

[Karavalkanov]

This is what I was actually looking for.
I am sorry if I did not express myself well enough.
Thanks!

[Karavalkanov]

I just thought it would take more than that- I do not really use that much excel functions.
On my original file, there are only 8 companies so I can insert the name of each company and place my results in 8 different tabs.

[63falcondude]

I was not expecting that to provide you with the result that you expected. Nevertheless, glad we could help.

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