Results 1 to 2 of 2

Retrieving one cell value based on other two columns cell value

Threaded View

  1. #1
    Registered User
    Join Date
    05-20-2011
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    5

    Retrieving one cell value based on other two columns cell value

    Hi to all!!!

    Herewith I am attaching the table


    Column 1 Column 2 Column 3
    Row 1
    a c Result
    Row 2
    a c 1
    Row 3
    b d 2
    Row 4
    a d 5
    Row 5
    b c 4


    -- Row 1 and Column 1 matching Cell -- and -- Row 1 and Column 2 matching Cell -- are input cells

    -- Row 1 and Column 3 matching Cell -- is Result cell

    My Requirement:

    If I enter "a" in --Row 1 and Column 1 matching Cell -- and "c" in
    -- Row 1 and Column 2 matching Cell -- means the corresponding value from Row 2 to Column 3 range cell has to display in -- Row 1 and Column 3 matching Cell --

    Ex:

    Row 1 and Column 1 Row 1 and Column 2 Row 1 and Column 3
    Input Input Result
    a c 1
    a d 5
    b d 2
    b c 4

    Your response will be highly appreciated

    Thanks with Regards,
    sathishrosario@gmail.com
    Attached Files Attached Files

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