Finding values in table A and transfering them to table B

[Sech1]

I have this list of companies (about 50) in one work sheet. If a certain company has sales or costs it will appear under the company name, as either Products, Installation or Freight.

What formula should I use the find the installation that belongs to that certain company? And not all companies has a line that say installation.

Please see attachment for example.Example.pdfExample.pdf

[Fotis1991]

Hi and welcome to the forum.

Be sure that best way to describe your problem is to upload a sample workbook.

Be sure that all sensitive data removed, showing what data you are working with, a few examples of what your expected outcome is, and how you arrived at that.

To attach a small sample workbook.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[kvsrinivasamurthy]

Pl see attached file with ARRAY formula.

[Sech1]

Than you kvsrinivasamurthy. But it is not serain that each company will have freight either, so I guess this mught be an impossible case to solve..

[kvsrinivasamurthy]

Does as all the company names are available in the same order.

[Sech1]

What do you mean, same order?

They are lined up like this:

10001 Company xxx
10002 Company yyy
10003 Company qqq
10004 Company rrr
10005 Compnay bbb
................ etc

[kvsrinivasamurthy]

Same order of all companies in Table A and Table B, Without missing any names.

[Sech1]

yes, same order i both tables.

[kvsrinivasamurthy]

Pl see the attached file.

[Sech1]

Than you. I have now used the formula in your excel sheet, but instead of getting the value for installation ("Installasjon" in the attached example), it finds the value above. I'm not really sure what I am doing wrong.

[kvsrinivasamurthy]

Pl see the corrected formula in attached file.

[azumi]

Different Approach
=IF(D2="10000 cccccccccccc",VLOOKUP($E$1,$A$2:$B$16,2,FALSE),IF(D2="10200 xxx",VLOOKUP($E$1,$A$18:$B$38,2,FALSE),IF(D2="10300 ssssss",VLOOKUP($E$1,$A$40:$B$61,2,FALSE),IF(D2="10400 Jvvvvvvvvv",VLOOKUP($E$1,$A$63:$B$82,2,FALSE)))))

Azumi

[Sech1]

Thank you very much kvsrinivasamurthy and azumi. This has helped me a lot!!

[kvsrinivasamurthy]

Thanks for the feed back.Pl mark the thread SOLVED.