Hi,

I have a spreadsheet that calculates hours worked and wages due based on an
hourly rate. If people work on public holidays then the rate is different. I
have the public holidays for the year in a separate sheet in array B4:C13 (2
years of holidays) in a short date format like 26-Oct, 27-Oct etc. On my main
worksheet I have the date in the same format in cell B3. What I need to do is
if the date in B3 is in the array B4:C13 (in the separate sheet) meaning that
it is a public holiday, then I need to apply a multiplier to the rate - for
example the rate may be doubled or more. Which lookup option should I use for
this?

regards,

Scott