Hello! I am trying to make a product that when parameters are entered (the year, rank, years in service all yellow boxes) then the monthly rate will auto generate from searching the pay tables that are on the document. My question is, I changed the pay charts to table so it would be easier to search. using an IF function, how can I change it to search the tables with other parameters? Or what would be a better function to make this work?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Searching Multiple Pages
- Thread starter EBiggs17
- Start date
