Results 1 to 5 of 5

Use values as coordinates based on another sheet, formula?

Threaded View

  1. #1
    Registered User
    Join Date
    05-27-2009
    Location
    Bucharest Romania
    MS-Off Ver
    Excel 2007
    Posts
    29

    Question Use values as coordinates based on another sheet, formula?

    Hello,

    For the excel file in the attachment i am trying to do the following, but i don't seem to find the answer:

    Based on choosing a product type, (p1, p2, p3, ... pn) data will be taken from that sheet only, doing the following.

    In the first sheet i can input W and H, and using those W and H as coordinates, a value will be automatically given.

    Example: P1 values: if i imput in the first list H of 2250 and W of 1830, i want to see the value coresponding to those coordinates, that is 423, in my case.

    BUT if the value is greater, i want it to choose the next line or the next column,... and based on the example above, let's say i need a H of 2252 with 1830, i want to be given the answer 433.

    If i am not understood, correctly, please ask for additional info

    Thank you,

    Cristian
    Attached Files Attached Files

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