VLookup or VBA...

[dlorenzo]

From what I can tell, I would either need VBA or a TON of IF statement VLOOKUPS to accomplish what I am going for.

I want to be able to lookup a certain sheet within a workbook based upon the date.

I have the following cells (account1-511 is in cell B1 -- company1 is in cell A2)
account1-511 account2-511 account3-511
company1
company2
company3
company4
company5

I want to be able to look up the value for company1 in account1-511. The account1-511 and other accounts will changed based upon the date. The date for the example given is 05/11. The account will be account1-611 for 06/11 and so on.

So, when the date is (05/11) I want to look up company1 on SHEET named account1-511. When the date is (06/11) I want to loko up company1 on SHEET anmed account1-611...and so on.

Possibly there is an easier way or different naming convention for the sheets that I may be able to use.

I'm not positive how to even write this in VBA or if it can be done as explained. Any help is appreciated.

Thank you.

[StephenR]

Can you post a sample workbook?

[dlorenzo]

This should be a sample for you, I think that I attached what I need to.

[NBVC]

Try this formula:

=VLOOKUP($A9,INDIRECT("'"&B$8&"'!A:B"),2,0)

copied down and across the matrix.

[dlorenzo]

Try this formula:

=VLOOKUP($A9,INDIRECT("'"&B$8&"'!A:B"),2,0)

copied down and across the matrix.

Absolutely PERFECT!!!

Thank you so much.