VLookUp Formula
Nana250
✭✭✭✭
Hello - I would like to use a VLookup formula to pull dates into a column of a sheet I'm working on. The scenario: Column 2 needs to pull in a date from the reference sheet for the same company of the row i'm working on. The company name may not be exact.
Example:
Sheet 1 - work in progress
Column 1 Column 2
Company name Opening date (date to pull in)
Sheet 2 - Reference Sheet
Column 1 Column 2
Name Date
Thanks for your help in advance.
Tags:
Answers
-
Melissa Yamada
melissa@insightfulsheets.com
Data made simple, spreadsheets reimagined
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.5K Get Help
- 448 Global Discussions
- 145 Industry Talk
- 481 Announcements
- 5.1K Ideas & Feature Requests
- 85 Brandfolder
- 152 Just for fun
- 73 Community Job Board
- 492 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 304 Events
- 37 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!