Matching multiple criteria
I'm having trouble writing the right formula for column B on the detail tab of the attached workbook. I think the problem is related to trying to match a date against text, but I don't know what to do to make them both the same type. Desired outcome would be that the result in B9 would be "R", the result in B10 would be "C2", and the result in B13 would be "E2".
Last edited by narrowgate88; 09-23-2010 at 02:22 PM.
To match the text date to number date, put the number date inside the TEXT function. Also, you have your ROWS and COLUMNS backwards. The formula should be
=INDEX(OrderedTable,MATCH(H9,ORDEREDProject,0),MATCH(TEXT(E9,"mmm yyyy"),OrderedMonth,0))
Does that work for you?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
That worked perfectly. I didn't realize that you had to match the row before the column. Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks