matching Multiple columns in Excel.

  • Thread starter Thread starter Manish
  • Start date Start date
The vlookup worksheet function will do what you are asking without the need
for VBA progamming.
E1: =vlookup(B1,C1:D6,2,False)

Note: this will bring back the first match. If you have multiple matches in
column C and they might have different values in D, then vlookup is not a
good solution, but there isn't enough information here to know if that
occurs, and if so, what algorithm you would want to use to resolve it.
 
Hello Ker,
Thank you very much for the reply,

Column B is the master Data column, Column C is the sub columns. All the
data from Column C exists in B and only once.

So when there is a match for any entry of C in Column B, then the
corresponding value of D should be copied to a new COlumn E and use the same
row as B

The excel sheet i have is like this

Ip-address | MAC-address | Mac-address | port address

So the columns Ip address and mac -address are related and the column
mac-address and port-address are related.


i want to combine the 2 mac-address column into 1 master column with the
correct ip address , mac-address and port address. For data that doesnt
match it should give NA in the port address field.


Hope this helps,

Once again Thanks a lot for replying
 
Back
Top