Hi guys, new to the forum.
I am trying to look up some data in two different worksheets dependent on
the row and column, the attached is the data i want to look up.
So basically I will have a carbon copy of this spreadsheet and I want to
say lookup "a" in row and return aug data from column, lookup "a" in row
and return sep data etc, then it will be lookup "b" in row and return
aug data, lookup "b" in row and return sep data.
I am pretty sure it is something to do with index and lookup but cannot
figure it out.
Thanks in advance
+-------------------------------------------------------------------+
|Filename: Book1 (2).zip |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=422|
+-------------------------------------------------------------------+
--
tealy