Vlookup - copy a date to another sheet
Hey,
I would like to use a vlookup to copy a due date to another sheet. The vlookup works in other cases, just with the date it doesn't and I get #INVALID COLUMN VALUE as a result. I know it has to do with the date itself but I am unable to figure this out myself :-) - can someone help?
The formula:
=IFERROR(VLOOKUP(([name]@row + group@row + "release"); {Produktion Bereich 2}; 9; false); "")
the date format ist German, so DD.MM.JJJJ
Thanks a lot in advance :-).
Best Answer
-
That particular error indicates that your column that is housing the formula is most likely not set as a date type column.
Answers
-
Hi @NeuerNutzer
I would try using INDEX MATCH or INDEX COLLECT formula instead of the VLookup.
Use INDEX MATCH if you only have one criteria that you are matching to pull your value, but if you have more than one criteria you are matching then use INDEX COLLECT.
The above link shares the difference between vlookup, Index Match and Index Collect.
Hope this helps.
-
Hey @Gillian C ,
thanks so much for your quick answer, unfortunately I get the same result with Index & Match:
=INDEX({Produktion Bereich 2}; MATCH(([name]@row + group@row + "release"); {Produktion Bereich 3}; 0); 9)
it still says #INVALID COLUMN VALUE
Both the Vlookup or the Index&Match work with other text-columns
-
That particular error indicates that your column that is housing the formula is most likely not set as a date type column.
-
Hey @Paul Newcome ,
thanks - it was that simple =D - works now both with the Vlookup and the index formula!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!