View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
D.Jessup D.Jessup is offline
external usenet poster
 
Posts: 7
Default 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