Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Quote Matrix
I am trying to set up a matrix (see attached) that will search a range (GT and LT) in columns and rows and return a value from the table where the X and Y search will intersect (line speed). The look-up needs to loop in the column until the search returns as true and then satisfies the row search. My excel in VBA is limited and have tried to resolve with formulas but have been unsuccessful. Thanks in advance for any assistance Roger +-------------------------------------------------------------------+ |Filename: Quote Matrix_Test..txt | |Download: http://www.excelforum.com/attachment.php?postid=4382 | +-------------------------------------------------------------------+ -- blyr1020 ------------------------------------------------------------------------ blyr1020's Profile: http://www.excelforum.com/member.php...o&userid=31742 View this thread: http://www.excelforum.com/showthread...hreadid=514552 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Matrix Problem | Excel Discussion (Misc queries) | |||
Matrix calculation | Excel Discussion (Misc queries) | |||
How to identify entries in a matrix also present in another list | Excel Worksheet Functions | |||
Recreate the upper part of a symetric data matrix 75x75 | Excel Discussion (Misc queries) | |||
Finding Values in a "Matrix" | Excel Discussion (Misc queries) |