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...