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
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