LinkBack URL
About LinkBacks
Untitled.png
Help.xlsx
Hopefully everyone will understand this picture. Any formula or vba for this?
I understand the first part:
=INDEX(Sheet1!D:D, MATCH(G719, Sheet1!H:H, 0))
but the date range is hard. i keep getting errors.
VBA or Formula Index Match Issue (Illustration Provided)
Untitled.png
Help.xlsx
Hopefully everyone will understand this picture. Any formula or vba for this?
I understand the first part:
=INDEX(Sheet1!D:D, MATCH(G719, Sheet1!H:H, 0))
but the date range is hard. i keep getting errors.
Try this:
=INDEX(Sheet1!$D:$D,MATCH(1,(Sheet1!$H:$H=G719)*(Sheet1!$J:$J=R719),0))
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
You don't have any End Dates in column J of your sample file.
Pete
In A719 copied to full range
Formula:
Please Login or Register to view this content.
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
NEVER use that sort of formula with whole columns. It will be VERY slow, as MATCH will look every one of Excel's 1,000,000+++ rows . Instead use sensible ranges.
=INDEX(Sheet1!$D$2:$D$300,MATCH(1,(Sheet1!$H$2:$H$300=G719)*(Sheet1!$J$2:$J$300=R719),0))
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: Lá fhéile Pádraig sona dhaoibh
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks