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
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 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!