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")
It's difficult to read the details in your attached files but i guess the formula should be like:
=VLOOKUP(C3;Table1!B2:C10;2;FALSE)
if the name of the table is Table1. If it's AD-Export then try
=VLOOKUP(C3;'AD-Export'!B2:C10;2;FALSE)