Hello Everyone. I have a complicated lookup that I need to do. I have two separate excel workbooks. For simplicity purposes we can use workbook A and B. there is a blank column in Workbook A that has to be filled with data from Workbook B. Here is the scenario that must occur, please let me know if this is possible. I need the blank column in A look up a value in a cell from A. Take the value from A and match it to the same value in a specific column in B. Once this is matched in B, it must grab a value from that Row, but a difference column, and fill the blank Cell in A.
Here is the situation in normal terms. I work for a health care organization, and we are getting a report sent to us with a CPT (Procedure) code in it. We need this CPT code to have a Technical Charge associated with it. WE want to take the CPT code and do a lookup in the Charge master, and fill the blank column with the Hospital Charge Code.
ANy help would be greatly appreciated. I have had NO experience with lookups like this, so you will be bailing me out with help!!!