Hello,
I need help to creating formula with matching date, please see below attached picture
I want to match firstly D column with I and J, if that is true that want to match E column with N and want to get result from P column.
Thanks
Hello,
I need help to creating formula with matching date, please see below attached picture
I want to match firstly D column with I and J, if that is true that want to match E column with N and want to get result from P column.
Thanks
You probably need to start out with a test for the dates, then pull the match. Something like...
=if(and(D2>=$I$1,D2<=$J$1),index(P:P,match(E2,N:N,0))
If that doesnt work for you, please read the yellow banner above
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Try this
=IFERROR(LOOKUP(2,1/($D$2:$D$8>=$I$1)/($D$2:$D$8<=$J$1)/($E$2:$E$8=$N1),$F$2:$F$8),"")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks