# Looking for better formula of iferror, index and match

1. ## Looking for better formula of iferror, index and match

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

2. ## Re: Looking for better formula of iferror, index and match

what do you want to improve?

3. ## Re: Looking for better formula of iferror, index and match

Originally Posted by martindwilson
what do you want to improve?

Is there a function that can replace index and match?

p/s: Let me know if my explanation to my question is clear.

4. ## Re: Looking for better formula of iferror, index and match

Hi DavidRoger

What's the issue with using the INDEX & MATCH. Why do you need to replace the function!

There are currently 1 users browsing this thread. (0 members and 1 guests)