Excel Index Formula Not Working

ssblue
ssblue used Ask the Experts™
on
Excel Index formula not working

Please see attachment - Explain why formula is not working and how to fix it.
Index-issue.xlsx
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Analyst Assistant
Commented:
Try changing the formula to this,

=IFERROR(INDEX(Sheet2!$B$1:$B$3619,MATCH(TRUE,ISNUMBER(SEARCH($B11228,Sheet2!$A$1:$A$3619)),0)),"Not Found")

and entering it with CTRL+SHIFT+ENTER.
ssblueCoordinator

Author

Commented:
That worked, thanks!!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial