Best function for my situation
 

Hi all,

I've got a table I've made which I want to search depending on other
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), and
a column with the pay type (standard, time + 1/2 and time x2) this is
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 then
display the corresponding figure?

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

Many thanks for any help

Phil


--
phil si
------------------------------------------------------------------------
phil si's Profile: http://www.excelforum.com/member.php...o&userid=16513
View this thread: http://www.excelforum.com/showthread...hreadid=313694

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

"phil si" wrote:


Hi all,

I've got a table I've made which I want to search depending on other
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), and
a column with the pay type (standard, time + 1/2 and time x2) this is
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 then
display the corresponding figure?

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

Many thanks for any help

Phil


--
phil si
------------------------------------------------------------------------
phil si's Profile: http://www.excelforum.com/member.php...o&userid=16513
View this thread: http://www.excelforum.com/showthread...hreadid=313694