Vlookup

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