How to combine columns using Vlookup?

March 2017


I have 4 columns A, B, C & D (sheet2) Col A got names and B a value for the name in A, Col C names and D values for the names in C. In sht1 i use Cell D7(Sheet1). In D7 is dropdown list with names that is in Sheet2 Col A & C. In Sht1 D21 i want to see the value of name in D7 whether the name is in col A or C on sht2.


So if the name bolt appear in D7, 403-01-02 must be in D21 sht1.

Used the below but i need to combine them!



Try this:


Solved by TrowaD


Published by aakai1056.
This document, titled "How to combine columns using Vlookup?," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (