I can do a regular vertical lookup but not quite sure how to do a double vertical lookup. I need to look up the state and then the county within my table to find the correct deductible. The lookup value for the state is in cell A12 and the lookup value for the county is in cell A13. The data is in cell K12:N500. The state is in column K, location is in column L, county column M and deductible column N
This question generated 23 answers. To proceed to the answers, click here.
This thread is current as of November 6, 2014.
For more resources for Microsoft Excel:
This article includes the following tags: