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)), "")

       

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

        HansVogelaar I'm uploading a copy of the file with some sample data

         

        Neither of the proposed formulas worked, unfortunately i don't want to rearrange the columns in AD Export sheet as there are other sheets from the file that are referring to this sheet and they have formulas that might break.

         

        regards

Resources