Load Family Door Count - Githubissues

afs1jes / Clarins-US-IR-Migration

0 stars 0 forks source link

Load Family Door Count #85

Open AVHuntley opened 1 year ago

RobSarajian commented 1 year ago

Data Load Report Sell In Sell Out with Door Counts-en-us_xlsx 2023-05-05 13-58-59.xlsx

File did not load.

AVHuntley commented 1 year ago

I made the same change here as on Load SISO Item Level.

The issue seems to have been with the Pyramid.MAP formula. I corrected it to:

=IFERROR(IF(AND(VLOOKUP(E2,Retailers!DataSet1,3,FALSE)<>0,VLOOKUP(E2,Retailers!DataSet1,3,FALSE)<>""),VLOOKUP(E2,Retailers!DataSet1,3,FALSE),"None"),"None")