X,Y,Z Match and Lookup

[amcmlt]

Trying to figure out a formula that would look at data in two different cells and use that data to locate the cell input out of a grid. Here is the grid as built today:


Run Length
2,500 5,000 10,000 20,000 50,000 100,000 100,001
Feeds Running Speeds
2 1,300 1,300 2,200 2,280 2,630 2,770 3,270
4 1,370 1,720 2,400 2,745 3,175 3,350 3,950
6 1,600 2,000 2,800 3,200 3,700 3,900 4,600
8 1,710 2,130 3,000 3,420 3,960 4,170 4,920
12 1,660 2,070 2,900 3,320 3,840 4,050 4,770
16 1,140 1,425 2,000 2,280 2,630 2,770 3,270
22 1,000 1,100 1,600 1,760 2,000 2,500 3,000
38 900 1,200 1,500 1,710 1,900 2,100 2,500
48 570 720 1,000 1,150 1,330 1,400 1,650

The hope is for the formula to look at cell V540 (Project Feeds = 8) and locate in the Feeds column (8 = I542) and then look at cell S540 (Project Run Length = 10,000) and locate in the Run Length Row (L537). With those two responses, formula to find the cross section of Feeds and Run Length and select Running Speed, which for this sample would be 3,000. Is this possible and if so, please point in the correct direction of writing this formula. I have no idea how to begin this one.

Thank you!

 

[Roderick_E]

sorry the jumbled text makes it impossible for me to understand

 

[amcmlt]

Sorry, do you have a email address I could send a snapshot of the grid?

 

[Macropod]

amcmlt: As per Rule #4 (https://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html) please don't invite another member to take the question off the forum. If you need to provide a table reflecting your workbook structure, use one of the tools designed for this that are mentioned in the 'Posting Aids' section of the Forum Guidelines: https://www.mrexcel.com/forum/board-announcements/127080-guidelines-forum-use.html

 

[amcmlt]

I will try to recreate the grid:

I J K L M N O P
Run Length
Row 537 2,500 | 5,000 | 10,000 | 20,000 | 50,000 | 100,000 | 100,001

Row 538 Feeds Running Speeds
Row 539 2 1,300 1,300 2,200 2,280 2,630 2,770 3,270
Row 540 4 1,370 1,720 2,400 2,745 3,175 3,350 3,950
Row 541 6 1,600 2,000 2,800 3,200 3,700 3,900 4,600
Row 542 8 1,710 2,130 3,000 3,420 3,960 4,170 4,920

The grid continues but hopefully this will work okay. Sorry about breaking the rules, I should have reviewed before asking.

 

[amcmlt]

Did not work either - I will try again to download one of the tools. Network issues will not allow at this time.