I spent all day yesterday trying to figure out how to get this array formula above here to reference the noted Table locations, but in an external workbook. Currently, the formula works as long as that HardwareTable resides within the same workbook, but I need it to reference that HardwareTable "externally". Both workbooks would be open by the time that this formula would run.
I've tried replacing the Table reference with an indirect reference but that wasn't working. No errors, just not working.
Here's a couple of examples of my indirect attempts.
These are arrays.
Thank you for any guidance or help with this. I'm starting to get cross-eyed staring at this for the past 8 hours.
-Mike
Bookmarks