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

1. ## 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.

2. ## 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. ## 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. ## Re: Need a formula to find the value listed at an X Y coordinate

Glad to be of help - thanks for the rep.

Pete

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

#### 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