I am creating a financial counseling tool for my fertility practice. I need to create VLOOKUP formulas to match CPT code with the insurance allowable amount, multiply it by a quantity which I will enter and display it by insurance company. I have a table with estimated allowable values (FEE tab) and the CPT codes by cycle type. Each tab at the bottom is a separate cycle. The "Practice Total" and "Laboratory Total" values should just be a sum of the vlookup values for each section. I can't get the vlookup to work! Help please!
Solved by G. E. in 20 mins