Results 1 to 11 of 11

**SOLVED** Multiple Lookup search in table and display separate table with matched values

Threaded View

  1. #1
    Registered User
    Join Date
    05-06-2015
    Location
    USA
    MS-Off Ver
    2013
    Posts
    2

    **SOLVED** Multiple Lookup search in table and display separate table with matched values

    Hi,

    Trying to create a formula to create a New table from an Existing table.

    It'll have (3) lookup values. You'll need to enter the values in the (lookup values) area.

    Load Capacity (Enter one: 500#, 1000#, 2000# or 4000#)
    Emission Type (Enter one: Gas, Diesel or Electric)
    Horse Power (Enter one: 150, 200 or 250 or 300)

    After entering all (3) lookup values, it would check the Existing table for all matching values and display the matching values insides the New table.

    I've searched and found I can do this but with only (1) lookup value.

    I've attached an excel file showing the (1) lookup value that works for Load Capacity.

    Can someone help me out? Is there an easier way, using formulas?
    Attached Files Attached Files
    Last edited by socals13guy; 09-15-2015 at 11:47 AM. Reason: Solved my question & excel formula

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Help with table lookup using matched text
    By staticsnake in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-15-2014, 01:33 PM
  2. [SOLVED] Search for multiple string values in the first row of a table and format column values.
    By Excel_junky in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-12-2013, 12:48 PM
  3. Lookup in one table and display two values in another
    By pafranklin in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 12-01-2012, 05:40 PM
  4. Replies: 3
    Last Post: 05-20-2011, 09:13 AM
  5. Display matched table data in another sheet
    By vanir in forum Excel General
    Replies: 2
    Last Post: 08-30-2009, 09:02 PM
  6. lookup values from multiple formula table
    By maacmaac in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-04-2009, 11:15 AM
  7. Lookup cell value in separate worksheet and return multiple matched values
    By jwhite68 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-19-2007, 12:17 PM

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