Results 1 to 4 of 4

Look up multiple values from table and return another value

Threaded View

ajw273 Look up multiple values from... 02-02-2010, 09:00 PM
Palmetto Re: Look up multiple values... 02-02-2010, 09:12 PM
Paul Re: Look up multiple values... 02-02-2010, 09:13 PM
ajw273 Re: Look up multiple values... 02-02-2010, 09:23 PM
  1. 02-02-2010, 09:13 PM #3
    Paul is offline
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,887

    Re: Look up multiple values from table and return another value

    Hi AJW, welcome to the forum. Please see the attached sheet for a possible solution. I created a merge column of the Item/Revision/Release on Sheet1 (column J) to perform a non-array lookup from Sheet2 columns D:H.

    =INDEX(Sheet1!D:D,MATCH($A2&$B2&$C2,Sheet1!$J:$J,0))
    Attached Files Attached Files
    - Paul

    Click here to read the Forum Rules

    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1