**Question description:**

*This user has given permission to use the problem statement for this blog.*

I have a ton of rows of data. Each row has the company name, revenue, and month and year, dating back to 2000. Some companies have 204+ rows of information if they have been open since 2000. I want to add a column for "Month Opened" and "Year Opened" since 2000. Each company has a unique name.
Basically, I want to automatically pull the first date that company showed up. That open date should be the same for that company on every row throughout no matter what month of revenue it is showing on that row.
How do I do this?!
Thank you.

Solved by F. E. in 12 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
20/04/2018 - 07:17

hello

User
20/04/2018 - 07:18

hello

User
20/04/2018 - 07:19

how do i automate this with a formula?

Excelchat Expert
20/04/2018 - 07:20

Automate what ?

Excelchat Expert
20/04/2018 - 07:20

Col E and F ?

User
20/04/2018 - 07:20

yes

User
20/04/2018 - 07:20

i have thousands of rows

Excelchat Expert
20/04/2018 - 07:22

Why row 5 is Jan 2001

User
20/04/2018 - 07:22

it is the first time it showed up

User
20/04/2018 - 07:23

i want to pull the first time that company showed up (month and year)

Excelchat Expert
20/04/2018 - 07:23

Ok

Excelchat Expert
20/04/2018 - 07:23

I see

User
20/04/2018 - 07:25

hm i think that worked? i cannot see the formula though..

Excelchat Expert
20/04/2018 - 07:26

This is the formula =VLOOKUP(A2,$A$1:B2,2,0) for column E

Excelchat Expert
20/04/2018 - 07:26

and form column F the formula is =VLOOKUP(A2,$A$1:C2,3,0)

User
20/04/2018 - 07:27

wow amazing! you area genius!

User
20/04/2018 - 07:27

are a

User
20/04/2018 - 07:28

yes!!!

User
20/04/2018 - 07:28

thank you

Excelchat Expert
20/04/2018 - 07:28

Anything else

Excelchat Expert
20/04/2018 - 07:28

?

User
20/04/2018 - 07:28

no thats all for now.

User
20/04/2018 - 07:29

thanks

Excelchat Expert
20/04/2018 - 07:29

Have a good day

User
20/04/2018 - 07:29

you as well

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*