VBA QUOTE

Closed
EILNAZK - Nov 27, 2009 at 08:18 AM
venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
- Nov 28, 2009 at 07:57 PM
Hello,
I am wondering if anyone can help me in writing a suitable quote in VBA.
I have panel data in sheet 1 (companies in different years) and also have name of companies with market index in different years in sheet 2. I want to match the name of companies in sheet 1 with the name of companies that I have in sheet 2 in each year and write the market index for each company in sheet 1 based on the information of sheet 2. I really appreciate if someone can help me.

Thanks

1 reply

venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
805
Nov 28, 2009 at 07:57 PM
requirement is not clear. what is meant by "quote"

From what I have understood you need vlookup function. read help on this function.
0