I need an index match formula to find text in a column and a date in a row.

[joshie78]

Hi,

I still can't get my formula to work.

I need a formula to find specific text in a column and then find a date in a row and return the value of that cell.

So, I want to find the text "average rent" in column A (40 rows of different text), then find the date of January 2014 in Row 5 and return the value of those two.

It has to be able to enter into cell in a separate sheet that I am pulling the formula from.

Please see "T12" I need to pull from the T12 into the quarterly asset review sheet.

Hope this makes sense.

[FDibbins]

You are having the same problem I showed you last time - you are mixing up text with numerics. January is text, a real date is numeric, remember the formula I gave you then...
MATCH(DATEVALUE("1"&Q$18&2014),'T12'!$C$5:$O$5,0)

Also, I notice that from Jan 14 onwards, your dates are the 14th of the month, not the 1st...
1/14/2014, 2/14/2014 etc
change them to the 1st day of the month

[joshie78]

I have changed them all to dates and still won't pull what I need.

I am just trying to get one cell to work and then go from there. I have been working with Q27 and it's just not pulling what I want. I am pulling my hair out.

[FlameRetired]

I changed:

Please Login or Register  to view this content.

to:

Please Login or Register  to view this content.

It works at my end.

The formula in your sheet was attempting to match text (&"*") value to a number (1/1/2014).