How to take data from another sheet using Lists

[riya]

Hi All,
I have List in Input sheet and want to pull the data from Data sheet. Suppose i select List as "Jeans" so the Jeans data have to appear in Input sheet.
Please help me any VBA code or Excel function.

 

[vletm]

riya
one possible way ...

 

[riya]

riya
one possible way ...

Hi Vletm, Thank you. Can i do this from VBA? Actually in the INPUT file i get some data from a Macro hence the Index formula will overwrite that why i want to use code in VBA. it will also ok if i assign a BUTTON after LIST so user just select LIST value and press on BUTTON and i get output from DATA sheet.

 

[riya]

Hi Vletm, Thank you. Can i do this from VBA? Actually in the INPUT file i get some data from a Macro hence the Index formula will overwrite that why i want to use code in VBA. it will also ok if i assign a BUTTON after LIST so user just select LIST value and press on BUTTON and i get output from DATA sheet.

Hi Vletm, If possible please help me out on the above.

 

[vletm]

riya
If You write Please help me any VBA code or Excel function. It would also mean that.
You sent same file back ...
How someone else would even guess
which ranges would be sensitive with Your other functionalities?
Of course, I would test test test ... that's not good idea from Your side.
You should know what would You like to get/see ... not others!

 

[riya]

riya
If You write Please help me any VBA code or Excel function. It would also mean that.
You sent same file back ...
How someone else would even guess
which ranges would be sensitive with Your other functionalities?
Of course, I would test test test ... that's not good idea from Your side.
You should know what would You like to get/see ... not others!

Aplology Vletm. That was my mistake. i didn't ask properly. After implement i get to know that excel function will not work. sorry again.