I need to return 40 to 102 cell values in a row for a specified numerical value of the first cell of that row. The values are needed in a different worksheet other than where the data resides.
For eg., I have 100 rows of data in Sheet 1. In Sheet 2, in row 10 starting from column B to say Column Z I need the values of columns say either B to Z or G to AE from the row in Sheet 1, where column A from A2:A101 equals exactly 2010 (Which is in fact the value of the first column in row 10 of Sheet 2 (A10 = 2010).
Any help is greatly appreciated.
Bookmarks