Please help: autopopulating a column on one sheet depending on values in another

[Supersadie]

I have a worksheet I need to autopopulate to save me spending another few nights manually copying and pasting! Can someone please help me?

Worksheet has sheet 1 containing:

Column A - business ID
Column B - companies

Each company has a unique company number.

Sheet 2 contains

Column B - person ID (each person has a unique number
Column C - business ID

One or in most cases several people will belong to one company.

I want to populate column A in sheet 2 with company names according to the company ID.

So I'm saying - if on sheet 2 cell in column c has such and such an ID, look at sheet 1 to find the matching ID in column a and see which company is on the same row in column b, then return that value in the relevant cell in sheet 2 column a.

Make sense? Can some kind soul help?

Best wishes...

[Fotis1991]

I think YES. This makes sense. Look's like an INDEX & MATCH issue..but it will be better if you upload a sample workbook.

To attach a small sample workbook.

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

View Pic

[alansidman]

=vlookup(Sheet2!C2,Sheet1!$A$1:$B$50,2,False)

I am assuming there are only 50 rows of data. Adjust as necessary. Also look here

http://www.techonthenet.com/excel/formulas/vlookup.php

[Supersadie]

Thanks alansidman
Actually, i should have made it clear that the sheet 2 and sheet 1 are in two different worksheets.
Worksheet sheet 2 is 'people' and worksheet sheet 1 is 'organisations'. I guess I need to specify that in the code.
when i paste the code in a dialog box pops up asking for a file name.
Thanks

[Supersadie]

Fixed!!

Just moved the columns from the other spreadsheet onto a new sheet in the existing doc for the sake of simplicity and changed the reference in the formula. Thanks so much!