Vlookup to pull in sales data based on the month sales begins

Hello,

I have two sheets of data (spreadsheet attached). The first sheet has monthly sales data by account, but does not take into account the starting month of each account - it just knows what the sequential sales will be month on month.

The second tab shows how many accounts come on board each month.

Is there a way to use VLookup, to interrogate the first sheet for the sales data, and add it to the second sheet so that the revenue is captured for each account, commencing from the month the account becomes revenue generating? Each account becomes revenue generating in the order they are listed.

Any help would be greatly appreciated.

Many thanks!

What would some expected answers look like?

This basic INDEX/MATCH will find the Acc and Month, and return where they meet. Note, it will only match the EXACT month name from each table
=INDEX('Sales Data_No Start Date'!$B:$AK,MATCH('Sales Data_With Start Date'!$A5,'Sales Data_No Start Date'!$A:$A,0),MATCH('Sales Data_With Start Date'!C$1,'Sales Data_No Start Date'!$B$1:$AK$1,0))

So.... do you mean that the blank sheet should look exactly like the completed one, except that the non-blank dta all start in month 1.... As they're all the same and you have shown no expected results, it's not a very helpful sample!!!

So, I guess all 3 of us are asking for sample answers?

How do you get acct 2 for mth 2 to be 0 when the data sheet shows 135?

Or any of the later months, for that matter

Is this what you want? In C5, copied across and down

=IF(ROWS(C$5:C5)<=C$3,INDEX('Sales Data_No Start Date'!$B4:$Z4,,SUMPRODUCT(--(LEN($B5:B5)>0))+1),"")

IF YOU INTEND to have data in column B of the results sheet, delete the +1 shown in red

Hi. You have 2 possible solutions at Posts 10 & 11. Have you looked at EITHER of them yet????

Originally Posted by adam_d_john

Hi FDibbins,

Acct 2 comes on board in month 2 and the first month of sales is $0.

Row 2 shows when a new account onboards.

- A

So MTH1 on sheet 1 does not correspond/is not the same mth as on sheet2?

You're welcome and thanks for the rep.