+ Reply to Thread
Results 1 to 2 of 2

Unsure of Formula to Use- IF function?

  1. #1
    Registered User
    Join Date
    09-07-2017
    Location
    Connecticut USA
    MS-Off Ver
    Office 2016
    Posts
    1

    Unsure of Formula to Use- IF function?

    Hi good afternoon,

    I need help with a basic formula, well at least I think it's basic.

    I Have a sheet in excel with 2 values, one is a text and one is a long string of numbers and letters, it looks like this:

    A1: ABC Company, Inc
    B1: 800610000000Xfo

    On my second sheet, I have to match up the long string of numbers/letters with the corresponding Company name from the first sheet. Basically, ABC Company, Inc appears on both sheets, but I need the string of numbers and letters to appear next to it if it appears.

    IF Sheet2 A4= ABC Company, Inc, THEN I need 800610000000Xfo to appear in that cell.

    Does anyone know how to do this!? thank you in advance for your help.

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Unsure of Formula to Use- IF function?

    b1=vlookup($a1,sheet2!$A$1:$B500,2,0) and drag down.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

+ 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. Function? If/Then? For Loop? Unsure how to solve this problem.
    By read_let in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-26-2017, 01:25 PM
  2. Looking for help with a formula as unsure how to do it
    By SophieLove81 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-20-2014, 12:21 PM
  3. [SOLVED] Unsure what formula to use to work out dates from table
    By steveori in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-24-2014, 09:19 AM
  4. [SOLVED] unsure how to wite IF formula
    By oceanside in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-14-2013, 11:32 PM
  5. Unsure what Formula to use to add up values relating to dates
    By Sarah Randall in forum Excel General
    Replies: 3
    Last Post: 03-06-2012, 01:06 PM
  6. Unsure how to properly execute tricky if function
    By dyoung6 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-18-2008, 01:02 AM
  7. Unsure what function to use
    By pjcassidy in forum Excel General
    Replies: 1
    Last Post: 03-06-2007, 01:35 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