Link to home
Start Free TrialLog in
Avatar of SDTSS
SDTSSFlag for United States of America

asked on

Excel IFERROR(Index when trying to locate an address

Hello Experts Exchange,

I have a client that recently added an address lookup feature in a workbook to check for an address across multiple spreadsheets in the same workbook. The address information in the workbook goes from 2007-present, but from my observation it is only returning data for certain years.
The error is =IFERROR(INDEX($A$6:$C$3000,$J6,COLUMNS($J$5:J5)),"").

Thanks in advance for any assistance!
eesnip.PNG
Avatar of Roy Cox
Roy Cox
Flag of United Kingdom of Great Britain and Northern Ireland image

Attach an example workbook.
Avatar of SDTSS

ASKER

The workbook is unfortunately on a shared drive that we do not have the rights to access. The best way we could describe it is there is one spreadsheet for each year leading up to 2016 and 2016-2019 are combined into one, with addresses, work order numbers, and a status field in each spreadsheet. The last "spreadsheet" in the same workbook is the address lookup tool.
It only requires a small example with names etc replaced with false ones.
This question needs an answer!
Become an EE member today
7 DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.