I have a pricing schedule in Excel, it has all potential service codes for a line of business in column A, B is blank for spacing, C-I Description (merged), J is price, K is units. Lets call this SHEET 1. I have a program that runs a sql query and exports data from our line of business software, provides Service codes in Column G (but ONLY the codes that customer currently uses), Price in column L. This is SHEET 2. Looking to have the the pricing for the sheet 2 overwrite the pricing for sheet 1, but only if it finds the service code. If if doesn't find the service code, I want it to leave the default value from sheet 1 alone.
Solved by K. Y. in 25 mins