Results 1 to 6 of 6

Excel Formula that references a table in a different worksheet

Threaded View

jtobes Excel Formula that references... 01-10-2011, 10:37 AM
royUK Re: Excel Formula that... 01-10-2011, 10:40 AM
NBVC Re: Excel Formula that... 01-10-2011, 11:02 AM
Barry.Cuthbertson Re: Excel Formula that... 09-01-2015, 09:51 PM
m.suheb Re: Excel Formula that... 10-24-2024, 08:42 PM
AliGW Re: Excel Formula that... 10-25-2024, 02:01 AM
  1. #1
    Registered User
    Join Date
    01-10-2011
    Location
    Boston, MA
    MS-Off Ver
    Excel 2007
    Posts
    1

    Question Excel Formula that references a table in a different worksheet

    Ok, So I made a table (on worksheet 'Load Chart') that has Crane Sizes going down the left (A Column), and in Row 1 I have radius of the pick, and cells B2:AJ14 are all the weights of the picks that correspond with the size of the crane and the distance(radius) the boom extends. With that said, I need to make some sort of generator on another worksheet that will allow me to input a certain weight of a pick, and the radius that I am picking, and have it spit out the size crane I should use. Now keep in mind the sizes vary and if the table doesnt have an exact match it would have to choose a value higher, as I am guaranteed to pick a crane that can handle a certain load. SO it should reference the column (radius), pick the nearest weight (that is same or greater than) and read the corresponding crane size in column A that matches the row that the size is in. I know its much but I hope someone can help me.
    Attached Files Attached Files
    Last edited by jtobes; 01-10-2011 at 10:40 AM.

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