+ Reply to Thread
Results 1 to 2 of 2

Need a Formula

  1. #1
    Registered User
    Join Date
    12-18-2010
    Location
    Coimbatore,India
    MS-Off Ver
    Excel 2007
    Posts
    2

    Smile Need a Formula

    Hi
    i need a help from any of u..

    I need to create small formula for the below case.

    i have set of data in A,B columns.. also i have a table like below..

    a1 a2 a3
    b1 b2 b3
    c1 c2 c3

    these values may or may not be present in the "A" column.

    Initially the formula need to check the "a1" in "A"column.if it presents it should print the
    value which is same row in "B" column, in the same a1 cell.


    thanks in advance...

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Need a Formula

    Welcome to the forum, rajesh.

    Would you please be so kind as to read the forum rules, and then change your thread title accordingly?

    Thanks.
    Entia non sunt multiplicanda sine necessitate

+ 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