+ Reply to Thread
Results 1 to 2 of 2

Looking for information on creating a formula in excel

  1. #1
    George A. Yorks
    Guest

    Looking for information on creating a formula in excel

    Looking to create a formula for the following. Sheet 1 column a have a list
    of names a1-a15. On sheet 2 have a list on names a1-a15 with list of numbers
    in c1-c15. If names from sheet 2 same as anyone on sheet one than the
    corresponding number will be posted. ie: on sheet one name george appears.
    on sheet two the name george in a1 and bill in a2 are listed. want to search
    that is george is found than the corresponding number will be posted on sheet
    3. Hope someone can make sense of this
    --
    George

  2. #2
    Tom Ogilvy
    Guest

    Re: Looking for information on creating a formula in excel

    Look in Excel help at the Vlookup worksheet function.

    Entries of this function would be on Sheet 3

    --
    Regards,
    Tom Ogilvy

    "George A. Yorks" <gyorks@comcast.net.(donotspam)> wrote in message
    news:70387687-9CC7-4C26-8F0D-E2F8DF77ABFC@microsoft.com...
    > Looking to create a formula for the following. Sheet 1 column a have a

    list
    > of names a1-a15. On sheet 2 have a list on names a1-a15 with list of

    numbers
    > in c1-c15. If names from sheet 2 same as anyone on sheet one than the
    > corresponding number will be posted. ie: on sheet one name george

    appears.
    > on sheet two the name george in a1 and bill in a2 are listed. want to

    search
    > that is george is found than the corresponding number will be posted on

    sheet
    > 3. Hope someone can make sense of this
    > --
    > George




+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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