VB Code to copy with critreria

[rizmomin]

Hello:

Please refer to attached file.
I need VB Code or formula (Vlookup) to copy data from Sheet1 at cell B18 of Sheet2.
The criteria is to match B9 and F9 from Sheet2 in Sheet1.
I have manually copied data as shown.
Let me know if you have any questions.
Thanks.

Riz

[AlKey]

Enter formula in B18 and copy across to C18 and down

=IFERROR(INDEX(Sheet1!D:D,AGGREGATE(15,6,ROW(Sheet1!$B$3:$B$103)/((Sheet1!$B$3:$B$103=$B$9)*(Sheet1!$C$3:$C$103=$F$9)),ROWS(D$18:D18))),"")

Please note that date in F9 should be 7/15/2016

[rizmomin]

Hi Allkey:

Thanks for great help.

Riz

[rizmomin]

Hi Allkey:

Can you help me change the above formula so that it uses the infinite data instead of until 103 as i will keep on adding data.
Please let me know if you have any questions.
Thanks.

Riz

[AlKey]

Hi Allkey:

Can you help me change the above formula so that it uses the infinite data instead of until 103 as i will keep on adding data.
Please let me know if you have any questions.
Thanks.

Riz

There are few formulas that will work with unrestricted ranges those are mainly SUMIFS or COUNTIFS and INDEX. However, I think you in this case would be better simply to extend ranges. Instead of 103 replace it 10003.

[AB33]

Hi Riz,
Code is attached.

[rizmomin]

Hi AB33:

Great work.
Thanks
Riz