Help with IF & AND Functions

Thank you for your reply,

Can IF Function work with arrays?

Help2.png

So i have a list of jobs and i wish to put them in a table (IMG Below)
like this which matches the job type for example Main, Meter, Service
and also puts it in the correct cell under the date
i am adding zero to Rates"Q337 because its a date,
when i tried using the DATEVALUE function for some reason it did not work

so Rates"Q337 is a date cell.


Help.PNG