Forum Discussion
Spreadsheet Help with Formulas Across Several Columns
One possible solution:
=INDEX('1C'!A:D,LOOKUP(B7,'1C'!A2:A509,ROW('1C'!C2:C509)),MATCH(B5,'1C'!1:1,0))
Hi John
It's better to provide a workbook than a bunch of photos.
I agree completely. Please see attached workbook. If you have any questions, please don't hesitate to ask.
One possible solution:
=INDEX('1C'!A:D,LOOKUP(B7,'1C'!A2:A509,ROW('1C'!C2:C509)),MATCH(B5,'1C'!1:1,0))That worked PERFECT!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
I have one more problem to solve with the same notebook.
On the main spreadsheet (Gauge), the Columns TEMP, API, and CORRECT FACTOR. I need cell K7 to get it's information based off the reference points of cell I7 and J7 from tab API.
On the API tab the Temp is the far left column and ranges from 30-119 degrees.
The API column header starts at B1:U1 with the corresponding APIs B2:B91 through U2:U91.
Simply put, I need the Correcton Factor to cross reference the temperature in relation to the API. This should work similar to the previous problem you just solved for me.
If you have any questions, PLEASE don't hesitate to ask! YOU'RE A GREAT HELP!!!!!!!!!!!!!
This time a slightly different solution.
=INDEX(API!$A$1:$U$91,MATCH(I7,API!$A:$A,0),MATCH(J7,API!$1:$1,0))