Hi All,
Here is my situation...
I have an excel file named "MD Names" that lists two columns:Every month, I run a report named "Blood Product Utilization" which will generate an excel file with following columns:
- A-MD Name [long list, about 10 pages]
- B-Dept
I then insert a column named "Dept" between "MD Name" and "Product Usage". Currently I manually type in the Dept name, using the source from "MD Names" file. Is there a function I can use to automatically fill/match "Dept" in "Blood Product Utilization" to MD Names, using "MD Names" file as reference?
- A-MD Name
- B-Product Usage
Any help will be greatly appreciated!
R
Bookmarks