All,
We have monthly reports that we have to do for received parts by vendor. Our issue is SAP displays vendors as numbers, but in our spreadsheet we want the numbers to show up as names (ie 601101 = Best Buy). We have like....70-80 something vendors on this list per month. What is the best way I can create a formula so I can just add it to our monthly report to basically do "If 601101, display Best Buy; If 601102, display <vendor B>" etc.
Bookmarks