VLOOKUP paste all data from that row to destination if match [easy for most]

which result you want in Q5

First observation: VLOOKUP() can only search for values in the first column of lookup_table. It appears that your stock tickers are stored in column B and not column A, so something is not right there.
Second observation: I note that your lookup_table reference is relative. I expect you want this to be an absolute reference (Read here if you are unfamiliar with using relative and absolute references: https://support.office.com/en-ca/art...es_in_formulas )
Third observation: Your column_index_number argument is an array, but you have only selected one cell and have not array entered the formula.

With those observations made, corrections I made:
1) Select Q5:X5.
2) Press F2 to enter edit mode
3) Navigate to the references for the lookup_table argument and press F4 to convert to absolute references.
4) Edit the first reference in the lookup_table argument to be $B$6 instead of $A$6.
5) confirm entry with ctrl-shift-enter to make an array function.
6) copy and paste down.

Is that what you are trying to do?

Try with in "Q5"

Formula:

Please Login or Register  to view this content.

copy paste down.
If you want data from another range then you can change range accordingly.