+ Reply to Thread
Results 1 to 2 of 2

If statement? Or Replace?

  1. #1
    Registered User
    Join Date
    03-03-2013
    Location
    Charleston, SC
    MS-Off Ver
    Office 2007 Ultimate
    Posts
    18

    If statement? Or Replace?

    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.

  2. #2
    Forum Expert José Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: If statement? Or Replace?

    Hi
    I did a little table with some vendors (E2:F6) and gave him the name of Vendors. In cell A2 I put the following data validation formula
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    In B2 I put the desired formula
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    I attached the file Example_1
    Regards
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. if statement to replace values
    By param299 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-12-2014, 11:59 AM
  2. [SOLVED] Can You Put An IF Statement Inside a REPLACE Statement?
    By nevi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-21-2014, 07:34 AM
  3. [SOLVED] If statement, then sum, replace and delete.
    By christopherL in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 11-07-2013, 12:00 PM
  4. Replace 0s with blanks - IF statement
    By thomas.szwed in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-12-2007, 11:59 AM
  5. How do I use an if statement with Find and Replace
    By Gerald in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-03-2005, 06:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1