I am trying to use VLOOKUP to search a table whose location moves around depending on the data that are loaded. I want to insert computed row/column indices in the VLOOKUP formula but cannot figure out the ' and " syntax. I can store the values in hidden cells on the sheet that I can access. I am using R1C1 syntax. A pseudo code example would look like this:
VLOOKUP(Holdings!RC1,Summary!Rcell_location_1C1:Rcell_location_2C9,9,FALSE)
The two cells have calculated values that define the lookup table, and they are located on sheet "Summary". I can also assign workbook variable names to the cells and use those. What does the correct syntax look like for using computed values for the row and column values??
I am running Excel 2010 with Windows 7.
VLOOKUP(Holdings!RC1,Summary!Rcell_location_1C1:Rcell_location_2C9,9,FALSE)
The two cells have calculated values that define the lookup table, and they are located on sheet "Summary". I can also assign workbook variable names to the cells and use those. What does the correct syntax look like for using computed values for the row and column values??
I am running Excel 2010 with Windows 7.
