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