Results 1 to 12 of 12

Lookup value in a table and return adjacent column value

Threaded View

  1. #1
    Registered User
    Join Date
    11-13-2012
    Location
    uk
    MS-Off Ver
    Excel 2010
    Posts
    77

    Lookup value in a table and return adjacent column value

    Hi

    I am trying to looup a value in a table and reurn the adjacent matched column value. I have used index and match formula with no success. Please see the attached sample table where I have given the results that hopefully a formula can return. The values in the table can be in any column, e.g. op 50 in column H, E.

    Thank you for your help.
    Attached Files Attached Files
    Last edited by hoss88; 12-05-2012 at 07:43 AM.

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