• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Looking for better formula of iferror, index and match

bigjohn

New Member
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]
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
[/pre]
 
Back
Top