How do you have numbers search a grid to populate a specific cell? In the example below I want cell G 15 to be populated with the number in C17 where the distance "15", and the ManPower "2" intersect.
MacBook Pro 13″, OS X 10.11
The general case of finding the value at the intersection requires two MATCH functions to find the correct the row and column then uses OFFSET to return the value at the intersection. But your spreadsheet with integers going down the left and across the top allows you to use OFFSET by itself.
=OFFSET($A$1,F13,G13)
The general case of finding the value at the intersection requires two MATCH functions to find the correct the row and column then uses OFFSET to return the value at the intersection. But your spreadsheet with integers going down the left and across the top allows you to use OFFSET by itself.
=OFFSET($A$1,F13,G13)
Badunit, Thank you! This worked!
How do you have numbers search a grid to populate a specific cell?
