How do I find 1 cell value from a 35 Row 12 Column table?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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:

Where:
The actual mileage is in A1
and the actual Weight category is in A2

=VLOOKUP(A1,your_data_table,MATCH(A2,top_row_of_the_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-Pro
 
Check out the use of:

=Index(Tablerange,Match(rowlookup),Match(Column(Lookup).

It would do you nicely,,,
 
Back
Top