+ Reply to Thread
Results 1 to 4 of 4

Need a formula to find the value listed at an X Y coordinate

  1. #1
    Forum Contributor BeachRock's Avatar
    Join Date
    11-01-2011
    Location
    Oregon, United States
    MS-Off Ver
    Excel 2016
    Posts
    403

    Need a formula to find the value listed at an X Y coordinate

    I need a formula that will return the value on one sheet using coordinates provided on another sheet. See attached example of data.

    This is a mileage reimbursement form using a chart on a separate sheet where all of the distances between sites are located.

    If the Starting Location on MileageLog! in C11 is GOW and the Destination in F11 is COV, then the result for actual mileage listed in K11 should be 18 as is in the green cell on MileageChart! with GOW being listed in Column A on row 15 and lining up with the COV column (Col "I"). The values in MileageChart! Column A 2:36 are the same as the values listed in Row 1 C:AK.

    I don't have a formula right now. I've tried INDEX and MATCH and VLOOKUP with MATCH but they don't produce the flexibility needed based on the site selections.

    Thanks for any help you can provide.
    Attached Files Attached Files
    -------------
    Tony

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    23,141

    Re: Need a formula to find the value listed at an X Y coordinate

    You can use this formula in J11:

    =INDEX(MileageChart!$B$2:$AJ$36,MATCH(C11,MileageChart!$A$2:$A$36,0),MATCH(F11,MileageChart!$B$1:$AJ$1,0))

    Hope this helps.

    Pete

  3. #3
    Forum Contributor BeachRock's Avatar
    Join Date
    11-01-2011
    Location
    Oregon, United States
    MS-Off Ver
    Excel 2016
    Posts
    403

    Re: Need a formula to find the value listed at an X Y coordinate

    Thanks, Pete! I didn't realize I could use the Match function like that but, now that I see it, it makes perfect sense. :-)

  4. #4
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    23,141

    Re: Need a formula to find the value listed at an X Y coordinate

    Glad to be of help - thanks for the rep.

    Pete

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Find Friday following latest date listed
    By MusicMan in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-18-2014, 03:02 PM
  2. Date filter, find listed dates and delete whole row
    By zit1343 in forum Excel General
    Replies: 3
    Last Post: 04-25-2012, 08:16 PM
  3. Replies: 2
    Last Post: 11-08-2011, 09:14 PM
  4. Find (x,y) coordinate, given target Slope
    By scope951 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 06-03-2010, 03:43 PM
  5. return value of X coordinate and Y coordinate?
    By sbmoller in forum Excel General
    Replies: 1
    Last Post: 09-22-2007, 06:54 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