Compare Workbooks

[Rowesc]

I have 2 Excel Workbooks with medical information. Workbook A has internal productivity information by charge code. Workbook B has insurance reimbursement information by charge code. I am trying to extract a part of the reimbursement information from Workbook B and insert it into Workbook A. Is there a way to do this due to the fact that both workbooks are broken out using the same charge codes?

Thanks.

Rowesc

 

[stanleydgromjr]

Rowesc,

Welcome to the board.

Depending on the location of the 'charge code' column in workbook B, try VLOOKUP, or MATCH, INDEX.

Have a great day,
Stan