Hello,
So I have dates in columns AA to BC that are dates by week. And if any of those dates fall between the dates listed in columns N through U, it should return one of the values in columns G, I, K, or M.
I'm using:
=IF(AA2=MEDIAN(N3:O3),G3,0)*IF(AA2=MEDIAN(P3:Q3),I3,0)*IF(AA2=MEDIAN(R3:S3),K3,0)*IF(AA2=MEDIAN(T3:U3),M3,0)
but it's returning a 0 even if the dates falls between one of those ranges. What am I doing wrong? Please help!
Thanks,
antcor
Is this what you want?Formula:
Please Login or Register to view this content.
1. Include a sample workbook with an example of the result you want
2. Use [CODE] and [FORMULA] wrappers for your VBA code or excel formulas
3. If your question has been answered, mark the thread as SOLVED and click on the "Add Rep" star to thank whoever helped you.
In cell AA3, try this:
Autofill as required.
Please Login or Register to view this content.
Cheers,
Would you like to say thanks? Please click the: "Add Reputation" button, on the grey bar below the post.
Thanks k64 but that was just displaying a 1 instead of the values from columns G, I, K, M.
ConneXionLost, you're a lifesaver! That worked perfectly, thanks!
Oh, I thought that was what you wanted. If you want the values, then ConneXionLost's formula is best.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks