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:

=IFERROR(INDEX(Sheet1!$C$2:$C$88,SMALL(IF(Sheet1!$B$2:$B$88=OUTPUT!$A2,ROW(Sheet1!$C$2:$C$88),""),COLUMN(A1))),"")

with Ctrl + Shift + Enter not just Enter

and drag Down / Right

OOPS.. I think, I missed something..

Try this.. with another condition also..

Formula:

=SUMIFS(Sheet1!$C$1:$C$88,Sheet1!$B$1:$B$88,Sheet2!$A2,Sheet1!$A$1:$A$88,Sheet2!B$1)

Debraj

Thank u Very much

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

Try this Array Formula..

Formula:

=VLOOKUP($A2,IF(Sheet1!$A$1:$A$88=OUTPUT!B$1,Sheet1!$B$1:$C$88,""),2,0)

Thanks for the Feedback & Rep..

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