Quote Originally Posted by Excel Fox View Post
I am assuming columns A to D will be filled already. And you need to populate columns E to H. Correct?
Thank you for looking into this. You got it right...

Column A has company names and column B has IDs. Column C and Column D contains Lookup Values which i need to lookup in Column B.

Rick's code needs to be amended so that it takes columns C and D. Presently the code takes values from ONLY from Column C and lookup in Column A and populate columns E to H.