# Excel - IF Function Problem - Expert Solution

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.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.