PDA

View Full Version : Retrieve the values



sindhuja
12-22-2011, 09:19 AM
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

xld
12-23-2011, 09:31 AM
Don't understand. Suggest you draw up a worked through example.

sindhuja
12-24-2011, 08:29 PM
Sample worksheet has been attached for the reference.

-Sindhuja

mdmackillop
12-25-2011, 06:42 AM
=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?