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. "" as blank.
Sheet 1:
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
Bookmarks