Excel 2016 Error in Formula or its a bug?

Hi, welcome to the forum

I think the problem lies with your data, not excel or the formula. You probably have leading or trailing spaces in some data. But without seeing a sample of what you are working with, I cannot say for your.

Can you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

ok, do not enter this as an array. Adjust this for the range of rows you need, plus some room for expansion, do not list entire columns.

=INDEX(Sheet2!$I$1:$I$5000, MATCH(Sheet1!F1 & "-" & Sheet1!G1, INDEX(Sheet2!$D$1:$D$5000 & "-" & Sheet2!$E$1:$E$5000, 0), 0))

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

Please create a small version of your file, with only 50-100 rows of desensitized data. Then upload that directly here. You file should be well under 1mb at that point.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Possibly. I wanted to see a "small" version of the file to review the functions and layout. I still believe my suggestion ion post #3 is the way to go for a single formula matching against two search values. Just change the 5000 to a number that works for your data.

I tried to download your file 3 times, no luck.

To start with, change that formula to this - it will run faster...
=INDEX(Sheet1!C:C,MATCH('Tracking URLs'!A2&'Tracking URLs'!B2,Sheet1!$A$2:$A$2000&Sheet1!$B$2:$B$2000,0))

As Jerry pointed out, try to avoid using full column references inside an ARRAY formula

Then, you are getting an error because there is no match found. To overcome that, try this....
=IFERROR(INDEX(Sheet1!C:C,MATCH('Tracking URLs'!A2&'Tracking URLs'!B2,Sheet1!$A$2:$A$2000&Sheet1!$B$2:$B$2000,0)),"")

Range concatenation is inefficient.

Try it like this...

=IFERROR(INDEX(Sheet1!C2:C2000,MATCH(1,(Sheet1!A2:A2000='Tracking URLs'!A2)*(Sheet1!B2:B2000='Tracking URLs'!B2),0)),"")

Still array entered.

Any formula that works in earlier versions of excel should also work in later versions

Hi,

MATCH does not work with lookup values that are in excess of 255 characters - those are the items that return #VALUE! errors in your workbook. You may replace your formula with a LOOKUP formula instead:
=LOOKUP(2,1/(Sheet1!A:A=A2)/(Sheet1!B:B=B2),Sheet1!C:C)

Edited: I overlooked Tony Valko's earlier post, which also avoids this issue. Both formulas will only return #N/A when there is no match for the lookup values.