Best method to retrieve table data

D

D.Jessup

Greetings,

I have a large table I'm trying to extract data from:

____|60|60.5|61|61.5|~~~~|78.5|
13.5|12|12 |13|14 |~~~~|28|
14 |12|13 |13|14 |~~~~|29|

This table is 70 columns by 40 rows, I do have the lead row numbers and the
top column numbers referenced in cells on the worksheet.

VLOOKUP does seem to be somewhat appropriate, but I don't have anything
matching up 60 in column two, 60.5 in column 3, etc.

Would it be best to use some form of INDEX and MATCH? If so how would this
look like?

Thanks for any assistance.
 
M

Max

One way using OFFSET ..

Assume source table in Sheet1, with
col headers in B2 across (viz: 60, 60.5 ... 78.5 ...)
row headers in A2 down (viz: 13.5, 14, ...)

Then in another Sheet2 (say)

Assume
In A2: 14 (a row header value)
In B2: 78.5 (a col header value)

Place in C2:
=OFFSET(Sheet1!$A$1,MATCH(A2,Sheet1!A:A,0)-1,MATCH(B2,Sheet1!$1:$1,0)-1)
C2 will return: 29 from the source table in Sheet1. Copy C2 down to return
correspondingly for other sets of values in A3:B3, A4:B4, etc
 
D

D.Jessup

Max,
Thank you for your input, I did end up going with index and match:

=IF(ISERROR(INDEX('Female Tables'!$BB$4:CO$73,MATCH(((AE3+AI3)-AM3),'Female
Tables'!$BA$4:BA$73,0),MATCH(M3,'Female
Tables'!$BB$2:CO$2,0))),"",INDEX('Female
Tables'!$BB$4:CO$73,MATCH(((AE3+AI3)-AM3),'Female
Tables'!$BA$4:BA$73,0),MATCH(M3,'Female Tables'!$BB$2:CO$2,0)))
 
Top