Forum Discussion

dkehoe32's avatar
dkehoe32
Helper I
8 years ago

help with formula

I need to put this excell formula : =IFERROR(VLOOKUP(I115,'New 2018 Part Numbers'!A:D,4,FALSE),"2017 Part Number") into a BI column.  I115 referes to the "material" column and the "new 2018 part numb...
Need Help
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi dkehoe32,

 

Did my solution work? Or were there any errors? Can you share a sample?

 

Best Regards,

Dale

dkehoe32's avatar
dkehoe32
Helper I
8 years ago

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    8 years ago

    Hi dkehoe32,

     

    Seems you missed the blue part in the formula below.

    Column =
IFERROR (
    LOOKUPVALUE ( 'table'[Column D], 'table'[Column A], [Column I115] ),
    "Not found"
)

    Best Regards,

    Dale

    • dkehoe32's avatar
      dkehoe32
      Helper I
      8 years ago

      Hi, im still getting the same error

      • v-jiascu-msft's avatar
        v-jiascu-msft
        Microsoft Employee
        8 years ago

        Hi dkehoe32,

         

        Can you share your file, please? You can mask the data first.

         

        Best Regards,

        Dale