Vlookup with horizental to vertical

Hi Team

I have attached excel workbook for your refrence.
Every time insert vlookup formula in output sheet B2,C2,D2,E2,
My problem is there any direct formula which can i copy and paste.
any help much appriciate Thanks in advance.

Hi Visha,

Try This.

Formula:

Please Login or Register  to view this content.

with Ctrl + Shift + Enter not just Enter

and drag Down / Right

OOPS.. I think, I missed something..

Try this.. with another condition also..

Formula:

Please Login or Register  to view this content.

OOPS did I again miss something.. Yes... VlookUp.

Try this Array Formula..

Formula:

Please Login or Register  to view this content.

Debraj

Thank u Very much

Thanks for the Feedback & Rep..

BTW.. all above are working.. you can choose anyone..