# Index-Match Help

#### scoveg13

##### New Member
I'm currently using an index-match formula. Iin mty index-match formula, I'm pointing a cell that is built using an If-and statement. When I reference the cell in my index-match formula, I get #N/A. When I hard-code the cell, the index-match formula works fine. How can I get around this? I'm trying to avoid any an all manual entry/hardcoding.

I appreciate any and all response.

Thank you.

### Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.
Can you post your formulas?

Can you post your formulas?

=INDEX(\$X\$24:\$Z\$25,MATCH(\$R\$17,\$W\$24:\$W\$25,1),MATCH(\$Y\$13,\$X\$23:\$Z\$23,1))

=IF(AND(R13=2%,R15=10%),"2","1") <--- this is cell R17

Because my index/match is referencing the If/And formula, #N/A is returned in my index/match result. If I hard code the If/And formula cell to eithera 1 or 2, the index/match works fine.

Take the quotes out of your second formula.

=IF(AND(R13=2%,R15=10%),2,1)

Adding quotes stores the numbers as text, not as integers.

Take the quotes out of your second formula.

=IF(AND(R13=2%,R15=10%),2,1)

Adding quotes stores the numbers as text, not as integers.

Thanks! I must have overlooked that...being that it's friday and all :D It works like a charm

You're welcome.

Replies
4
Views
114
Replies
10
Views
246
Replies
3
Views
207
Replies
3
Views
198
Replies
0
Views
112

1,207,402
Messages
6,078,264
Members
446,324
Latest member
JKamlet

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back