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