Best method to retrieve table data
 

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.
--
Just an ordinary Joe

Best method to retrieve table data
 

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"D.Jessup" wrote:
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.
--
Just an ordinary Joe

Best method to retrieve table data
 

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)))
--
Just an ordinary Joe


"Max" wrote:

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"D.Jessup" wrote:
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.
--
Just an ordinary Joe

Best method to retrieve table data
 

No prob. Go with something which you feel comfortable with.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"D.Jessup" wrote in message
...
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)))
--
Just an ordinary Joe