I am trying to create a worksheet that pulls information from other worksheets to create a calculation guide for products my company sells. I am having difficulty using the Index and Match functions when I go across worksheets. For example, I want to pull the price corresponding to the item (card holder) and the size of the product (3x5). Here is my current formula:
=INDEX('Two Sided Top Open'!$D$2:$D$3,MATCH('Calculation Sheet'!A3&'Calculation Sheet'!B3,'Two Sided Top Open'!$A$2:$A$3&'Two Sided Top Open'!$B$2:$B$3,0))
Even after pressing ctrl, shift, enter, I get a N/A value. Do you guys know how I can resolve this? Should I be using Vlookup instead?
I have attached the document that I am trying to fix. The problem is under the calculation worksheet. Any help would be much appreciated!