Results 1 to 24 of 24

Index & match help

Threaded View

  1. #1
    Registered User
    Join Date
    10-20-2015
    Location
    Michigan, USA
    MS-Off Ver
    Office 2016
    Posts
    18

    Index & match help

    Hello,

    I am looking what I believe to be a formula with index and match, but cant figure it out. What I am looking to do is create a spreadsheet for my window business that can look up prices for me instantly

    I have 4 columns: EXAMPLE

    window type ; height ; width ; price

    SH ; 24 ; 36 ; $100
    SH ; 24 ; 50 ; $200
    SH ; 30 ; 36 ; $150
    SH ; 30 ; 50 ; $250

    i need a formula that compare the window type, the height and width and then spit out the price. the problem is i need the height and width to be variable, meaning if a window is 26 x 36 it will give me the 30 x 50 price ; if its 24 x 38 it will give me the 24 x 50 price...obviously i will have more window types than SH so I need that to be exact match and the height and width to be ranges and spit out the price i need. Can someone help me with this formula?

    Thanks in advance!
    Attached Files Attached Files
    Last edited by BMBme; 10-21-2015 at 10:42 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Match-Index in stead of Index-Match lookup Array among Arrays
    By Numnum in forum Excel General
    Replies: 2
    Last Post: 10-15-2015, 02:08 PM
  2. INDEX MATCH MATCH/OFFSET MATCH MATCH with named ranges
    By Andrew-Mark in forum Excel General
    Replies: 3
    Last Post: 02-27-2015, 10:56 PM
  3. Replies: 6
    Last Post: 04-30-2014, 02:42 AM
  4. [SOLVED] Index Match from a cell populated from index match
    By MarcLewis in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-15-2013, 05:30 AM
  5. Replies: 6
    Last Post: 11-08-2013, 10:29 PM
  6. Replies: 3
    Last Post: 05-02-2013, 01:31 AM
  7. Replies: 5
    Last Post: 02-29-2012, 08:51 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