index/match or vlookup question over multiple columns

sample.xlsxGood afternoon!

I need a formula that will look at a date in a particular cell on a worksheet titled "Payroll" and match it to a date in one of twelve columns as pictured in my attachment and then when found have the formula provide as the answer the letter in the same row located in column "O". So for instance if the date "2/06/16" was in sheet/cell "Payroll!BQ2", the formula would compare that date to my pictured chart below and would then provide me the answer "H", which was located in the same row, but in column "O". I have tried multiple if statements, but that didn't work for me, at least how I was trying it. As always, I'd be grateful for any suggestions and/or help!

am i right in saying that the day determines the code

so can we just have a column of days 1-31 and the codes ?
then the lookup would work easily

rather than attach an image can you attach a spreadsheet

Please upload a sample of your workbook to the forum, Make sure you have removed any private information, remember this is a public forum and so available to anyone
Would like to see an example of your data and also a manual mock up of the expected results you want to achieve.

To attach a file to your post,
click "Go advanced" (next to quick post),
scroll down until you see "manage Attachments",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

i have added a column of numbers for DAYS()
assuming my question is correct

am i right in saying that the day determines the code

so can we just have a column of days 1-31 and the codes ?
then the lookup would work easily

see attached

Hi lilsnoop from Michigan,

In your attached picture all calendar day of 1 start in row 2, and you have that as a C in that row....

How about making this a much easier formula.

You give me a date and I'll do a =Day() formula with your date. This will tell me what day of the month it is. I'll take the Row(Day(<your date>)).

I'd then use this number to look in your table in Column O for the letter you need.

The Letter = Index($O$2:$O$32,Row(Day(<your date>)))

I hope this helps.

your welcome thanks for the rep

This will do it without any extra columns...
=INDEX(Sheet1!$O$2:$O$32,MATCH(Payroll!FM2,OFFSET(Sheet1!$C$2,0,MATCH(EOMONTH(FM2,-1)+1,Sheet1!$C$2:$O$2,0)-1,30,1),0))

Happy to help and thanks for the feedback, both of you