Lookup & Time Formatted Cells ([h]:mm;@)

Hi there,

I have a spreadsheet that I need to have lookup values from a exported csv file based on weekending date, name and Time Type. (please see attached files). Either lookup from the csv file or lookup from the csv file opened in Excel .... either would be OK.

I have manually entered the data for one person (Susan Ball) but I would like the other data to be imported automatically.

I also need to conditionally format column R. (which is formatted as [h]:mm;@) as:
0-250hrs = normal clear cell
250-280hrs = yellow cell
280-300hrs = Blue Cell
> 304hrs = red cell

TIA.

Stewie.