Vlookup - copy a date to another sheet

NeuerNutzer

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 :-).

Paul Newcome

That particular error indicates that your column that is housing the formula is most likely not set as a date type column.

Gillian C

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.

https://www.smartsheet.com/content-center/best-practices/tips-tricks/3-formulas-look-up-data-smartsheet

The above link shares the difference between vlookup, Index Match and Index Collect.

Hope this helps.

NeuerNutzer

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

Paul Newcome

That particular error indicates that your column that is housing the formula is most likely not set as a date type column.

NeuerNutzer

Hey @Paul Newcome ,

thanks - it was that simple =D - works now both with the Vlookup and the index formula!

Paul Newcome

Happy to help. 👍️