Results 1 to 6 of 6

Multiple Criteria V-H Lookup Formula/Macro

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-29-2012
    Location
    Manila, Philippines
    MS-Off Ver
    2019
    Posts
    102

    Multiple Criteria V-H Lookup Formula/Macro

    Hi gurus,

    I'm faced with yet another challenge that might be simple for you guys. Attached is the sample workbook for your reference.

    On click event, cells in the "OUTPUT" sheet need to be filled in with data from the "database" sheet. The challenge for me is that each cell needs to meet the criteria based on Column A ("Item Part Number") and Rows 2 & 3. The challenge for me is that I want to achieve this using the cell function or formula (as I am trying to limit the macro usage of this workbook). You may come up with a macro program as a last resort.

    Hope you guys can help me with this and advance thanks!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Lookup with Multiple Criteria Formula
    By J-L-S in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-07-2019, 02:59 AM
  2. [SOLVED] Lookup & sum based on multiple criteria macro
    By jscalem in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 11-17-2015, 05:07 PM
  3. [SOLVED] Multiple Criteria and Value Lookup Formula
    By FinanceGQ in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-10-2015, 10:12 AM
  4. Need help with a multiple criteria lookup formula
    By JOHN NIXON in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-15-2014, 01:54 AM
  5. Replies: 1
    Last Post: 05-16-2011, 05:00 PM
  6. Lookup formula - multiple criteria
    By realmfighter in forum Excel General
    Replies: 6
    Last Post: 09-13-2009, 10:02 AM

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