Need help with INDEX function

[Galrash]

Hello,

I am trying to create a formula for calculating a value automatically based on intersecting points on a table. After some research it looks like the INDEX and MATCH functions are the most suited to help me.


Here is what I currently have in cell I5:

=INDEX(W16:AA21,MATCH([@[Total Net Order Conv Rate]],W15:AA15,1),MATCH([@NABV],V16:V21,1))



I am getting the #REF! error and I can't figure out why. Any help would be much appreciated!

[FDibbins]

Please upload a sample of your workbook, not a picture of your data. Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
Also, not all members can upload picture files (Company firewalls and stuff) - and, depending on what browser is being used, some pics dont even show up on the forum

Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.

However, it looks like tou have the 2 MATCH ranges wrong. The 1st match range needs to be a single column range, and the 2nd MATCH needs a row range

[Galrash]

Sorry about that, I uploaded the excel file.

I changed it to match the column first and then the row, thanks for that tip I had no idea the order mattered!

All I am trying to figure out now is how to get it to apply the same exact formula to the entire I column automatically

edit - I figured it out. Thanks for the tip on the column before the row!