I am having trouble indexing a date that falls in a range and there is another criteria to match in order to get the result I want. Can someone help me with my formula? It is not selecting the correct information.
{=INDEX(Rates2!$C$2:$F$37,MATCH($D10&$A10,Rates2!$C$2:$C$37&IF($A10>=Rates2!$E$2:$E$37,IF($A10<=Rates2!$F$2:$F$37,"")),1),MATCH("Timeframe",Rates2!$C$2:$F$2,))}
(deleted)
Retroactively double-posted. Mysterious.
Last edited by daffodil11; 09-19-2013 at 03:59 PM. Reason: time machine malfunction, resulted in double post in the past
Your row match criteria got a little out of control.
{=INDEX(Rates2!$C$2:$F$37,MATCH($D10&$A10 this has no matches ,Rates2!$C$2:$C$37&IF($A10>=Rates2!$E$2:$E$37,IF($A10<=Rates2!$F$2:$F$37,missing IF true,"")),1),MATCH("Timeframe",Rates2!$C$2:$F$2,))}
You should only looking for a row between the date ranges, and if True pulling back those rows.
From there, you're matching those rows to only the city.
Here you go:
Please Login or Register to view this content.
Last edited by daffodil11; 09-19-2013 at 03:59 PM.
Hi daffodil11,
Yeah, that worked great! You made it simpler for me...thank you!!
Still learning!!!
No problem, glad I could help.
We're all students here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks