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"

 

 

 

 

 

ennlfrdeitptruestr
JSN Epic template designed by JoomlaShine.com