Hello
I am trying to extract a figure from sheet 2 into sheet 1.
Sheet 2 is a list of company names running across the sheet and running down the sheet are groups of services, with rows in the groups containing individual hourly rates by professions. The cells are the service rates by profession by company.
An average hourly rate has been calculated by company and service, 6 rows below the service category heading. There are 99 companies tendering for about 9 services.
On sheet 1 is a listing of all the companies running vertically and a variable cell relevant to the service beng tendered for.
I would like to be able to change the service on sheet 1 and have a formulae extract from sheet 2 the corresponding average hourly rate for each company.
There are a number of attempts at formulae that have resulted in nothing.
I would appreciate any help.
Thankyou
Gezza
Bookmarks