How to find variable reference columns with vlookup 1

[Poppaone]

I have a monthy finacial statement that shows results from a list of companies. The companies are listed in colums and the accounts are in column 1.

Sheet 2 - RESULTS
A B C D E
Co 1 Co X Co F Co R
1 Account1 XXX XXX XXX XXX
2 Account2 XX X,XXX X
3 Account3 XX XX
4
5

Sheet 1 - Summary

A B C D E
Co F ? <- this is a validation selections
1 Account1
2 Account2
3 Account3
4
5



I want to use vlookup to create a summary on Sheet 1 where the customer can select the company from a validation list ("Company F" in column D for example) and the financial results for Company F will populate the summary, based on the lookup results from the Results worksheet. How do I tell vlookup that the reference column is a variable based on the selection from a from a dropdown validation table selection? What would the code be that identifies the variable reference?

 

[SkipVought]

Hi,

You can use VLOOKUP for the account and MATCH for the company within the VLOOKUP, for the third argument.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Poppaone]

It works perfectly!

Thanks