Hey Guys - New to this forum, but I am having a lot of difficulty figuring out the code I want for a specific assignment.
I am working on a spreadsheet with two tabs. On tab one I have a list of doctor visits by patient with columns showing the ID number of the physician and the date the checkup occurred. On the second tab I have a list of contracted rates for each physican, but the rates vary depending on time frame (we usually contract for 6 months, 1 year, etc).
I want to match the ID number from tab 1 then go to tab 2 and find the associated physican, then go back to tab one find the start state of the doctor visit and then go back to tab 2 and then perform a vlookup for values on tab 2 (Columns D-F) based on when this individual saw the doctor (see which time frame the visit falls under and then perform the vlookup function on the appropriate row)
First table is Sheet 1 (Top Table), Second Table is Sheet 2 (Bottom Table)
<tbody>
</tbody>
<tbody>
</tbody>
I am working on a spreadsheet with two tabs. On tab one I have a list of doctor visits by patient with columns showing the ID number of the physician and the date the checkup occurred. On the second tab I have a list of contracted rates for each physican, but the rates vary depending on time frame (we usually contract for 6 months, 1 year, etc).
I want to match the ID number from tab 1 then go to tab 2 and find the associated physican, then go back to tab one find the start state of the doctor visit and then go back to tab 2 and then perform a vlookup for values on tab 2 (Columns D-F) based on when this individual saw the doctor (see which time frame the visit falls under and then perform the vlookup function on the appropriate row)
First table is Sheet 1 (Top Table), Second Table is Sheet 2 (Bottom Table)
<colgroup><col></colgroup><tbody> </tbody> |
<colgroup><col></colgroup><tbody> </tbody> |
<tbody>
</tbody>
<colgroup><col><col><col><col><col span="2"></colgroup><tbody> </tbody> | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
<tbody>
</tbody>