+ Reply to Thread
Results 1 to 2 of 2

VLOOKUP to match various factors?

  1. #1
    Registered User
    Join Date
    03-06-2012
    Location
    Rosenort, Manitoba, Canada
    MS-Off Ver
    Excel 2007
    Posts
    3

    VLOOKUP to match various factors?

    I'm working on a manufacturing costing sheet where I input the number of bends in Cell I3 a certain part gets. If the weight in Cell S3 or size in F3 of that part is over 60 lbs or 120 inches, it is to return a "1" or "2" answer to identify which list of bends and time factors to use =IF(ISNUMBER(I3),(IF(OR(S3>60,F3>120),(PRICESLIST!$N$18),(PRICESLIST!$N$11)))) PRICESLIST!$N$18 refers to the 2 identifying the 2nd chart. Then I want it to take the number of bends (between 1 and 4) and, in a new cell, give me the seconds from the correct chart.
    1
    No. of bends/part Seconds Factor
    1 80 1
    2 120 1.5
    3 160 2
    4 200 2.5

    2
    Big parts -over 120 in. length or 60 lbs.
    No. of bends/part Seconds Factor
    1 200 2.5
    2 300 3.75
    3 400 5
    4 500 6.25

    I've been using VLOOKUP, but have been getting errors. Is there a different way I can do this?

  2. #2
    Forum Contributor
    Join Date
    08-14-2006
    Location
    USA
    MS-Off Ver
    2019
    Posts
    686

    Re: VLOOKUP to match various factors?

    Use INDEX and MATCH()

    MATCH to find the correct Row in your correct Table
    MATCH to find the correct Column in your correct Table

    or post a sample of your workbook

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1