Finding Matching value in list and put fixed value or number or text in corresponding cell.

[amitdelpanwar]

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Subnet[/TD]
[TD]Mask[/TD]
[/TR]
[TR]
[TD]255.255.255.0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]255.255.252.0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]255.255.255.0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]255.255.255.252[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]255.255.252.0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]255.25.255.255[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Subnet Mask
255.255.255.0 = 24
255.255.252.0 = 22
255.255.255.252= 30
255.25.255.255 = 32

I want to put Mask value automatically in "Mask" cell in the list.

 

[Peter_SSs]

Is this what you mean?

Book1
	A	B	C	D	E	F
1	Subnet	Mask			Subnet	Mask
2	255.255.255.0	24			255.255.255.0	24
3	255.255.252.0	22			255.255.252.0	22
4	255.255.255.0	24			255.255.255.252	30
5	255.255.255.252	30			255.25.255.255	32
6	255.255.252.0	22
7	255.25.255.255	32
Mask

Cell Formulas
Range	Formula
B2	=VLOOKUP(A2,E$2:F$5,2,0)