Forum Discussion

Radoslavov91's avatar
Radoslavov91
Copper Contributor
Oct 25, 2021
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...
excel
HansVogelaar's avatar
HansVogelaar
MVP
Oct 25, 2021

Radoslavov91 

Your VLOOKUP formula looks up C3, i.e. the email address, in the first column of Table1.

But the first column of Table1 that is visible in your screenshot is Division. Does Table1 begin in column A? If so, you should have included it in the screenshot.

Better attach a stripped-down copy of the workbook with some dummy data.

  • Radoslavov91's avatar
    Radoslavov91
    Copper Contributor
    Oct 25, 2021

    HansVogelaar here is a new screenshot with sample data, and again is not working 😞

     

    Regards

     

    • Radoslavov91's avatar
      Radoslavov91
      Copper Contributor
      Oct 25, 2021
      I've missed to add the formula as well: =VLOOKUP(C2;'AD-Export-2021-10-14'!A2:J12;2;FALSE)
      • HansVogelaar's avatar
        HansVogelaar
        MVP
        Oct 25, 2021

        Radoslavov91 

        VLOOKUP always searches for the lookup value in the first column of the range.

        Use

         

        =IFERROR(INDEX('AD-Export-2021-10-14'!$B$2:$B$12, MATCH(C2, 'AD-Export-2021-10-14'!$J$2:$J$12, 0)), "")

         

Resources