I need to use this formula time to time and then forget again how to use it. So, it is best to take my own note here.

Objective: In Sheet2 on column E, I need to use vlookup to bring the mac addresses from Sheet 3 by comparing and matching ip addresses

Explanation of the formula:

=VLOOKUP(D1,sheet3!$A$2:$B$470,2,FALSE)

First part, D1 is the value I am searching

Second Part, sheet3!$A$2:$B$470 is the area in which sheet and the cells I will look for the value I am searching for

Third part, 2 is telling the vlookup "Go and bring the value in the 2. cell"

Final part is False, telling vlookup "Bring the exact value"

 

 

 

 

 

Hylafax Installation on Debian

Easy to start HylaFAX is a free linux-based fax server. It is used by many companies worldwide. In this article, we are going to install and configure HylaFAX.

More...

Creating Multiple Users on Active Directory

Docs / SupportIf you are working in an organization which receives a lot new users on several periods of the year, then you should handle creation of domain users  with the help of Powershell. More...

How To Change Default Computer OU

Native RTL SupportWhen you join a computer to the domain, Computer Object is created and placed in Default Computer Container which is not an organizational unit and we all know that, GPOs can be only applied to Organizational Units. 

More...

© selimatmaca.com. All Rights Reserved.