Automatic Fill By formula

[lalro143]

Hi,

Can you suggest me how to automatically fill one column based on condition.

Condition:

Col A	Col B	Col C
56	open	Open
56	duplicate	Open
56	duplicate	Open
56	duplicate	Open
78	Closed	Closed
78	duplicate	Closed
78	duplicate	Closed
78	duplicate	Closed
78	duplicate	Closed

<colgroup><col width="64" style="width: 48pt;" span="3"> <tbody> </tbody>

I want to fill col C which is based on condition like shown above
if col A having same number with different status like 56 with 4 status in col B, I want col c will be filled with other status apart from "duplicate" like "open". Pls suggest how to fill col C with Formula

 

[ParamRay]

.
.

In cell C2, enter this formula:

=VLOOKUP(A2,A:B,2,FALSE)

Then autofill down to the last row of data.

 

[lalro143]

Thanks for the reply...but what if case is below :-

<form name="vbform" style="margin: auto auto 1em;" onsubmit="return vB_Editor['vB_Editor_001'].prepare_submit(0, 1)" action="newreply.php?do=postreply&t=807196" method="post"> Col A</form>	Col B	Col C
56	duplicate	Open
56	duplicate	Open
56	Open	Open
56	duplicate	Open
78	duplicate	Closed
78	closed	Closed
78	duplicate	Closed
78	duplicate	Closed
78	duplicate	Closed

<colgroup><col width="81" style="width: 61pt; mso-width-source: userset; mso-width-alt: 2962;"> <col width="77" style="width: 58pt; mso-width-source: userset; mso-width-alt: 2816;"> <col width="69" style="width: 52pt; mso-width-source: userset; mso-width-alt: 2523;"> <tbody> </tbody>