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
Bookmarks