LinkBack URL
About LinkBacks
Hi,
I wanted to know how I can use vlookup so that if I type in a stock's symbol I automatically get its respective company name price, eps, P/E ratio, etc.
Hi,
I wanted to know how I can use vlookup so that if I type in a stock's symbol I automatically get its respective company name price, eps, P/E ratio, etc.
Hi Usc123,
Welcome to the forum.
This can be achieved using vlookup as =vlookup(<stocksymbol>,<datatable>,<columns positions of company name price etc>,False). In case you face issues or your data is arranged some other way, please upload a sample workbook. Thanks
Regards,
DILIPandey
<click on below 'star' if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), dilipandey@gmail.com
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks