Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Change Data In Pivot Table | New Users to Excel | |||
Another Exciting Data Table Question!!!! | Charts and Charting in Excel | |||
Sort pages? | Excel Discussion (Misc queries) |