software

I have a 35 row, 12 column stratified speadsheet that I have tried IF and
LOOKUP functions to find values but am hampered by their constraints. Any
suggestions as to how I would find a single value based on rows of various
mileages and columns of various wight brackets?

Without your actual data structure....here's a guess at what might work:

If:
Mileage increments are down the left column of the table
Weight categories are across the top row of the table
and the intersections of Mileage and Weight are what you're looking for:

Whe
The actual mileage is in A1
and the actual Weight category is in A2

=VLOOKUP(A1,your_data_table,MATCH(A2,top_row_of_th e_data_table,0),1)

That should find the mileage that is nearest to the actual mileage in the
first column of the table and return the corresponding value under the
appropriate weight category.

Does that give you something to work with?

***********
Regards,
Ron

XL2002, WinXP-Proquot;Herren'squot; wrote:

gt; I have a 35 row, 12 column stratified speadsheet that I have tried IF and
gt; LOOKUP functions to find values but am hampered by their constraints. Any
gt; suggestions as to how I would find a single value based on rows of various
gt; mileages and columns of various wight brackets?

Check out the use of:

=Index(Tablerange,Match(rowlookup),Match(Column(Lo okup).

It would do you nicely,,,
quot;Herren'squot; wrote:

gt; I have a 35 row, 12 column stratified speadsheet that I have tried IF and
gt; LOOKUP functions to find values but am hampered by their constraints. Any
gt; suggestions as to how I would find a single value based on rows of various
gt; mileages and columns of various wight brackets?