Hi,

I have a sheet in which I am trying to use mutliple criteria to define a result.

The premis is that a Company is selected in Col A, then a Role is selected in Col B, then a Shift Time is selected in Col B, this will then generate the relevant hourly rate using a table of rates on the second worksheet.

The formula works sort of for the first entry but once I start to mix up the Company / Role / Shift Time info it does not calc, same when copying down the sheet.

Can anyone help please ? :)

Thanks

Jim