Forum Discussion
Solved
VLOOKUP show wrong values
Hi all, i have the following problem with an excel function. I have a file with two sheets, sheet one (AD-Export) contains data for the employees (such as first name, email, department) and the s...
As HansVogelaar suggested
=IFNA( INDEX(Table1[Batch-ID], MATCH(Scouts!C2, Table1[mail], 0) ), "no such")
I am having a similar issue. I am can't seem to post photos but I would if it was possible. I am trying to use the Vlookup for dates but when i do this I get a #Value error.
That's better to discuss with sample file. Perhaps you have texts which looks like dates, not actual dates which in Excel are numbers in behind.