Full formula:
=IFERROR(INDEX('Sheet2'!$B$100:$B250,MATCH(C100/2,'Sheet2'!$C$100:$C$250,0)),"")
Can the formula be improved?
Details:
Formula is insert in Sheet 1 Column A. Sheet 2 is all data.
Sheet 1:
[pre]
[/pre]
=IFERROR(INDEX('Sheet2'!$B$100:$B250,MATCH(C100/2,'Sheet2'!$C$100:$C$250,0)),"")
Can the formula be improved?
Details:
Formula is insert in Sheet 1 Column A. Sheet 2 is all data.
Sheet 1:
[pre]
Code:
A B
1
30 2
3
30 4
5
30 6
7
30 8
9
30 10
11
30 12
Sheet 2:
A B
30 1
30 2
30 3
30 4
30 5
30 6
30 7
30 8
30 9
30 10
30 11
30 12
30 13