I have a very complex question on excel that I don't know if it can be done

[ak0812]

So Firstly I help with accounts in a hospital and on the spreadsheet I am asking help for on helps show what the doctors get paid. A lot of doctors pay gets messed up because its easy to make mistakes on.
What I require is we do different exam type so say I put MRI ankle it comes up under one part because it is a one part exam and then the doctors get paid on the rate of a 1 part of exam. If it is MRI both ankles that is a two part a exam and then I want that to autofill into 1st part and then 2nd part because the maximum we do are 4 part exams. So basically what I want is that depending on what exam type it is I want it to auto fill how many parts it is.

Kind regards
Andi

 

[Joe4]

Welcome to the Board!

Perhaps the following will help. You can create a lookup table that has rows for things like exam, parts, costs, etc.
You could then use a VLOOKUP formula to look up the details of a given exam.
See here for details: How to use the Excel VLOOKUP function | Exceljet

If you need more concrete help, please post some concrete examples, so we can see the data you are working with and how it is structured on your sheet.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.