Hi,
I've been trying to make a formula, which does the following:
I have 5 numbers which are references:
So sheet 2: cells B2:B6 could get dates from Sheet 1 field_array named field according to A2-A6
**Edited: this is so hard to explain. i'd like to lookup vertically the first nonblank cell in array and then lookup the date from the column of that nonblank cell.
1) Find the cell position of the first nonblank cell according to number in column A on sheet 1.
2) Return the date from range Sheet1!B1:F1 for the number.
So the result should of the formula would be in sheet 2:
A B
1 | 2102 | 2.1.2015
2 | 2103 | 1.1.2015
3 | 2104 | 4.1.2015
4 | 2015 | 3.1.2015
5 | 2106 | 5.1.2015
Any ideas how to make this work? Sorry if you didn't get my idea... It's basically finding a field according to position. So i'd like to lookup vertically the first nonblank cell in array and then lookup the date from the column of that nonblank cell.
[table="width: 500, class: grid"]
worksheet.xlsx
Bookmarks