-
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.
medicine
-
E
Match data from 2 work sheets and return the result to the first worksheet
Hello, What I am looking for is vlookup type function that will look up the first 3 columns in data worksheet 1 and find it in the data lookup table and find the pay grade and if it is there return the Role Type to Data Sheet 1 Role Type. Data Worksheet 1 (8k rows) Division Name...- elanda
- Thread
- data medicine pay role type
- Replies: 3
- Forum: Excel Questions
-
D
Fixing a formula
I am seeking assistance in fixing a formula that is resulting in either #Div/O or #VALUE , here is my current formula, =COUNTIFS('Raw May'!E1:E1200,"General Medicine",'Raw May'!AU1:AU1200,"Yes")/COUNTIFS('Raw May'!E1:E1200,"General Medicine",'Raw May'!AU1:AU1200,"Yes",'Raw...- datadummy
- Thread
- column fixing formula medicine raw
- Replies: 4
- Forum: Excel Questions
-
M
Compare two comboboxes in Userform to check selected data can be selected or can not selected...
I have a problem as follows, in my medicine prescription userform I have 4 combobaxes containing medicine names, combobox1 is populate with col A in sheet 1, combobox2 is populate with col B in Sheet 1, combobox3 is populate with col C in sheet 1 and combobox4 is populate with col D in sheet...- mrxdm
- Thread
- col compare two comboboxes data medicine mixed
- Replies: 2
- Forum: Excel Questions
