Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
How to resize a comment box, by embedding code into a function? | Excel Worksheet Functions | |||
change function variable prompts?? | Excel Worksheet Functions | |||
Counting Function Dilemma | Excel Worksheet Functions | |||
IF Function or IF then else | Excel Worksheet Functions |