Hi,
As you can see from the attached file Ive an index match issue. Basically when one of my lookup values is repeated in the lookup column it returns an #N/A! error.
In the attached:
Look up ID: 2012
Look up Week: 2
Query Returns: 500 (CORRECT!)
Look up ID: 2012
Look up Week: 4
Query Returns: #N/A! (BOOO!!)
Im guessing it's limitation of Indexmatch? Although im not sure...........Anyone any ideas as to the issue/alternative?
Bookmarks