I am assuming columns A to D will be filled already. And you need to populate columns E to H. Correct?
I am assuming columns A to D will be filled already. And you need to populate columns E to H. Correct?
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
Thank you for looking into this. You got it right...Originally Posted by Excel Fox
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.
Posting Permissions
Reply With Quote
Bookmarks