Best function for my situation

[phil si]

Hi all,

I've got a table I've made which I want to search depending on othe
values on my sheet.

It's a table of workers and their charge rates.

There is a column with the grade of work (days afters nights etc), an
a column with the pay type (standard, time + 1/2 and time x2) this i
represented as 1,2,3

There is a grid with this info on...

Is it possible to say if grade = $grade and pay type =$type the
display the corresponding figure?

I've played with the lookup function but nothing seems to suite m
needs...

Many thanks for any help

Phi

 

[Guest]

Hi
have a look at INDEX /MATCH for this. See:
http://www.contextures.com/xlFunctions03.html