Retrieve the values

[sindhuja]

Hi,

Please assist with the below requirement.

Set of fields for which value to be retrieved based on the company code and the month.

Eg. Company code - 1000, month - Jan. These are the two condition fields for which values like Value 1, VAlue2, Value3.....Value 6 inputs to be retrieved in a sheet named consolidate. source data to retrieve the values will be in the same file with the sheets named as month. In this case, the criteria is "Jan" hence it should retrieve the values from the Jan sheet.
Similarly if i change the company code the field values should change accordingly

- Sindhuja

[Bob Phillips]

Don't understand. Suggest you draw up a worked through example.

[sindhuja]

Sample worksheet has been attached for the reference.

-Sindhuja

[mdmackillop]

=VLOOKUP($B$1,INDIRECT(B$3 &"!$A:$G"),ROW()-2,FALSE)

Please don't be so mean with sample date. If you can't take the time to make it up, why should we?