VLookup with If Function & multiple conditions

[Skaapie]

Hi,

Once again I turn to the genius's of the world!

I understand VLOOKUP.
I understand the IF Function.
I have attached the Sheet I am working on.

In short, when the user changes the Month and/or Date then the data displayed under "Today" must be for that particluar Month & Date which is found in the "data base" futher down in the spreadsheet.

In long...

1. The user can change the Year, Month and Date. (C1:C3) This will be the condition.Attachment 60461
2. When the Month and Date is changed, cell B5 (and B6,B7,B8 ect) must then display the relevant information found in cells B52:AO60 (this is for April only).
3. If the user changes the Month and/or Date then the information displayed under Today (B5:B13) must be retrieved from the same month and Date (found further down in the spreadsheet.)
4. The user can enter data under each day under each month (found further down in the spreadsheet.)

I have entered test data in cells C52:I55.

You help will be of great value and highly appreciated.

In advance, Thank you!


*** Please don't laught at the formula I have in B5. I was just trying to figure out how it might work.

[NBVC]

Try this in B5:

=INDEX($B$51:$AN$2030,MATCH($C$2,$B$51:$B$2030,0)+ROWS($B$5:$B5),MATCH($C$3,$B$51:$AN$51,0))

copied down to B13

Then in B16:

=INDEX($B$51:$AN$2030,MATCH($C$2,$B$51:$B$2030,0)+13,MATCH($C$3,$B$51:$AN$51,0))

copy formula down, but adjust the 13 to coincide with row number from B51 that you want to get info from.

[Skaapie]

Thank you NBVC!!!

I just copied your idea into B5 and it worked! I will apply your other suggestions and let you know how it goes.

Thank you, I have just learned more about excel and it is wonderful!

I really do appreciate your time taken and assitance given!

I will post the outcome soon.

Blessings.

[Skaapie]

After a few modifications on my side I was able to successfully apply your formulas and it was great!

I really do appreciate your assitance! It was a HUGE time saver and a great learning experience.

Keep up the great work!

[NBVC]

Thanks a lot for the feedback!