Good afternoon,
My name is Nadine and I am looking for help on trying to solve get this formula to work or you have a better way to help me get what I need, that would be appreciate!
I have two workbooks, one being larges and have several rows and columns. One column has Claim numbers in it (there are several rows before that column) and one is a blank column that I need to have net savings automatically put into. There are several columns in between these two.
My second workbook has the claim numbers that I need to search and find on the first workbook and then return then return the correct net savings that is in a different column on this second workbook. I only can search 9 out of the 11 digits that are in the claim number due to the last two digits are different in each workbook.
Thank you so much in advance for your help!
Nadine
=INDEX('[CORVEL_CLEAN_BILLING 051818 after Clearing.xlsm]CORVEL_CLEAN_BILLING CA 051818'!$G$2:$G$9, MATCH(LEFT('[CORVEL_CLEAN_BILLING 051818 after Clearing.xlsm]CORVEL_CLEAN_BILLING CA 051818'!$H$2,LEN('[CORVEL_CLEAN_BILLING 051818 after Clearing.xlsm]CORVEL_CLEAN_BILLING CA 051818'!$H$2)-2),LEFT(E96:E283,LEN(Claim_number_column: E96:E283)-2),0))
Bookmarks