I am trying to match dates in columns B and D with dates in Column H and put the respective amounts in column I and J respectively. I have manually put in the amounts at the moment and looking to see if a formula would do this for me. Thanks.
I am trying to match dates in columns B and D with dates in Column H and put the respective amounts in column I and J respectively. I have manually put in the amounts at the moment and looking to see if a formula would do this for me. Thanks.
with just 2 columns
put this in say h2 drag across to i2 then down
=INDEX(B$3:D$100,FLOOR(ROW(A2)/2,1),1+MOD(ROW(A2),2)*2)
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Not sure what criteria you are using. For example Nov 22,2011 (H6) is not between D3 and B3 but you give it the value in C3?
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks