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
dkehoe32's avatar
dkehoe32
Helper I
8 years ago

its meant to say A: D not the smiley face

  • 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