I am trying to write a function to use Match and Index to perform a lookup down a column and across two rows for a more complex lookup. I have a spreadsheet where row 3 uses the formula which works but my VBA function is now working as called from row 4. The formula bar is showing C4 passing the parameters. My actual application is more complicated with case conditions with more parameters and the lookup tables will be on various worksheets. I am trying the simple method first. I am wondering if it’s a limitation of the Index being used in the VBA.

I am trying to write a function to use Match and Index to perform a lookup down a column and across two rows for a more complex lookup. I have a spreadsheet where row 3 uses the formula which works but my VBA function is now working as called from row 4. The formula bar is showing C4 passing the parameters. My actual application is more complicated with case conditions with more parameters and the lookup tables will be on various worksheets. I am trying the simple method first. I am wondering if it’s a limitation of the Index being used in the VBA.

I am trying to write a function to use Match and Index to perform a lookup down a column and across two rows for a more complex lookup. I have a spreadsheet where row 3 uses the formula which works but my VBA function is now working as called from row 4. The formula bar is showing C4 passing the parameters. My actual application is more complicated with case conditions with more parameters and the lookup tables will be on various worksheets. I am trying the simple method first. I am wondering if it’s a limitation of the Index being used in the VBA.

I have two separate tables, one containing the location information and current quarter in a fixed position.