VBA QUOTE

Closed
EILNAZK - Nov 27, 2009 at 08:18 AM
venkat1926 Posts 1863 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 response

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
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