How to list matching value for a horizontal (row) search

**mobie86** · 05-07-2013, 05:09 PM

Hi everyone,

I don't really know how to explain what I need. I attached a made-up small sample of what my worksheets look like. Every Month I have to pull up what reports are due for that month;my spreadsheet are to long to and it's becoming more difficult to find who has a report due this month.

I need a formula to look up a row(horizontally) and list the value that matches what I'm asking for. In this case, a Month/Year.

This is what my data looks like (the grey is what I would like to auto-generate with a formula if possible)
HELP.jpg

I have tried modifying index, match, vlookups, hlookups- and I'm not getting anywhere!

Thank you in advance for you help!

**abubaniyan** · 05-07-2013, 05:27 PM

please explain step by step there is nothig in the world which you can't explain.

first be clam and generate a creteria , for results in a grey cells....!

**mobie86** · 05-07-2013, 05:36 PM

Yes, I would like enter the formula on the Grey Column. I just plugged in numbers for now to show what I need the formula to generate.

I don't want to go through each column and find which ones have a report due that month. Instead, I want it to look through the row and list the date, if it matched my month/year, or "NA" is the client has no report due that month. In this case I want it to display the date for May 2010(Cell: G4 on excel spreadsheet)

Sorry I'm bad at explaining things!