Vlookup

[Former Member]

Hello gurus,

I have data in excel in 10 sheets with two columns..like tcode and no of hits for the different plants.

i would like to make column chart in xcelsius with plant drop down and in x-axis with tcode and y-axis with no.oh. hits

i try to work with vlookup but i could not make it

please help.

adavance thanks

Muvva

[Former Member · Accepted solution]

can you please provide more information? like, does each sheet have it's own list of unique codes or are there duplicates across the sheets that need to be aggregated?

is tcode the same as plant code?

[Former Member · Accepted solution]

Thanks for your msg. I got the solution for that.

I would like to ask you i would like to display the data using web service. could u pls give me idea how to do it.

Thanks

Muvva

[Former Member]

Please go through the sample especially Filtered Rows/Alert-Selectors/Dynamic Selection one,you will get an idea of how to implement it.

[Former Member]

Thank you for your suggestion. i am able to use the radio button for the filter the data.

but i am trying to use the drop down option for my data but i could not able.

Any way thanks for sharing your idea with me.

Muvva