Read from Columns and write in rows

Hi all,

I am a little messed up.

My knowledge of excel is kinda good but I have a problem with 'thinking the right way'. Specially it is almost midnight here and I am tired.
I searched a lot how to do this but I believe I can't express myself to google good enough to get the right answers.

So,

I have Sheet1 where I got the invoice informations. Where I get the client's name from Sheet2 with Client code.
On Sheet2 I have these columns:

A1 A2

Client Number Client Name Service Service Service
1 ABC CLEAN HELP PLEASE


so I want to VLOOK or INDEX or MATCH somehow and get this result in Sheet1


Service
CLEAN
HELP
PLEASE


long story short, get a match information from a row and write the results in a column.

I hope I am clear enough....

Thanks in advance





Edit: To be more clear:

the attached file has invoice sheet,

invoice.xlsx

if you choose a client number where the borders are RED , the client NAME appears in the line where the borders are GREEN,
and with that name from the GREEN AREA, I want to MATCH the name from the CLIENTS SHEET and return the service values on the columns nearby and write them in the ORANGE AREA in INVOICE Sheet

Hope this was more clear

Thanks

Instead of having 4 formulas you can just use one.

In B12 and copy down

=INDEX(Table[[Client Name]:[Service3]],MATCH($B$11,range,0),ROWS($B$12:B12))