Get Associated Values

Hello Guys

I am trying to make something similar. But i am not so good with excel.

I like to make some standard report

IF i write Name in first field A1, that it go to table in another sheet and collect data from Table and add it to this 3 fields
Can i make it with Excel formulas or i need to use macros?



It need to be something like this
IF A1 IS SAME AS ONE OF THE FIELDS IN (TABLE) COLUMN A THAN USE DATA FROM THAT RAW. AND ADD THEM TO FIELD A2 - B2 - C2 - D2 - E2

TABLE WITH DATA

Please help.

Google VLOOKUP, it is very straight-forward.

Thank you, sorry i am not so good with excel.
And also this parts was not so easy for me.
It was easy when you know what to try to find

Thank you one more time :rapture:

Can you post small sample workbook? and type manually the desired results...........

Click "Go Advanced" button and find paperclip image button to attach your file...........


regards

I am new on this website and need to have 5+ posts to be able to add any file.

Does VLOOKUP have limit for table, how big it can be ?