create a macro to to vlookup multiple values

[vivek_work]

i have attached the file for which i want solution, all my query is mension in tab if any further question please ask and please give solution as soon as possible thanks in advance

[:) Sixthsense :)]

Make use of Pivot Table like the attached file.

Check the Pivot Sheet for expected output. Place the cursor in A2 cell of Pivot Sheet and make the selection you would like to see.

[vivek_work]

Thanks for the Help but I dot want to use Pivot and other thing is I want to exclude certain model.

[:) Sixthsense :)]

Ok.. But I don't like to go for some other approach when it can be achieved easily using Pivot. I believe someone will fulfill your expectation.

[vivek_work]

thanks you so much for looking for into my problem and giving me solution.

[jindon]

try

Please Login or Register  to view this content.

[vivek_work]

Thanks jindon

your solution is very good but you just left one thing that i had metion that it should not include pulsar

if he has sold pulsar then it should not show any other models sold by him only there should be his name nothing else. Thanks for you reply it is very helpful for me.

[jindon]

want to exclude certain model.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[vivek_work]

i am not a vba programmer so i dont know where to put this code please povide full code

[jindon]

if he has sold pulsar then it should not show any other models sold by him only there should be his name nothing else.

Please Login or Register  to view this content.

[vivek_work]

Thank you so much you have solved my big problem thank you dear thanks a lot for you help..

[vivek_work]

thank you great work,

[jindon]

?
You're welcome.