How to get exact data from dropdown list

Hi
I have a very very emergency question !
I have a woorksheet that I should get a data from big of data.
I should create a dropdown list, and when select a name of the client in a next cell automatically shows just 2 of the data.
For instance I have a client with 15 records. In another I choose the name of the client and in a table automatically appear some data about company that like the name, or Id . not all the 15 records.

I hope you can help me ...

Originally Posted by aidda

Hi
I have a very very emergency question !
I have a woorksheet that I should get a data from big of data.
I should create a dropdown list, and when select a name of the client in a next cell automatically shows just 2 of the data.
For instance I have a client with 15 records. In another I choose the name of the client and in a table automatically appear some data about company that like the name, or Id . not all the 15 records.

I hope you can help me ...

Hi Aidda,

Please see the file looks for this..? hope this can help u.

Best Regards,
Jitendra

Originally Posted by aidda

thank you very much !
I think you solve my problem ! I use this code to my worksheet and I hope it is work for all of them
Thanks again

you are welcome...
yes offcourse u can drag the formula down and you have your results.

Originally Posted by aidda

I just have another question.
If in sheet 2 the title of cell is something like " Cost of product B" and I want to show the amount of that cell in sheet 1 but the name of cell is " Cost of B", how does it work ?

hi,

You can use simple vlookup for it,

see the file.