Forum Discussion

dkehoe32's avatar
dkehoe32
Icon for Helper I rankHelper 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
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi dkehoe32,

 

Could you please mark the proper answer as a solution?

 

Best Regards,
Dale

  • dkehoe32's avatar
    dkehoe32
    Icon for Helper I rankHelper I
    8 years ago

    I have not found the solution yet

    • v-jiascu-msft's avatar
      v-jiascu-msft
      Icon for Microsoft Employee rankMicrosoft 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
        Icon for Helper I rankHelper I
        8 years ago