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 numbers AD referring to two columns from that excell file which is in BI as well.

Need Help

9 Replies

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

      Hi dkehoe32,

       

      The formula could be like below. But the result would depend on your data structure. You can give it a try.

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

      Best Regards,

      Dale

      • 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