VLOOKUP with 2 conditions
Hi
I hope some one can help me :
I have 2 sheet one to enter data from form & other to record( update row )
i need formula to take start time from first sheet to update in second sheet wit tow condition ( name & date )??
thanks
Answers
-
Something I have done in the past is a little trick to make each record unique.
I create a helper column in both sheets with something like "=[Employee Name] + Date" then when you do the vlookup you lookup the unique value. This way there is only one record for the Employee and Date combination
Brent C. Wilson, P.Eng, PMP, Prince2
Facilityy Professional Services Inc.
http://www.facilityy.com
-
Thanks a lot ,, i try and its working now ..
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 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!