Excel Formula

[VKKT]

Hi
Greetings,
I have one excel workbook (attached) with cell B contains the "box no." and cell C contains the "boxes effected"
I want a formula to show in the remarks column of all the boxes which are effected as "Not Billed". I have around 46000 records to fill like this.

Regards,
VKKT

[HansV]

Can you explain what the formula should do?

[VKKT]

Hi Mr. Hans,

Where ever the Nos in "Box No." matches with the Nos. in "Box Effected" then the remarks column will show as " Not Billed"

Regards,
VKKT

[HansV]

I don't understand the values in your sample workbook. Why is D2 blank while D3 has "Not billed"? Why is D16 blank?

[adeel1]

I assumed that you want to find Col B values in col C if found then “not billed” otherwise keep blank

=IF(SUMPRODUCT(--(B2=C:C))=0,"","Not Billed") or also can use like =IFERROR(IF(MATCH(B2,C:C,0),"Not Billed",""),"")

[VKKT]

Yes, this is the formula I am looking for.
Thanks Mr. Adeel for your help.

Sorry Mr. Hans for raising an unclear question.
Regards,
VKKT

[HansV]

I'm glad that Adeel has solved your problem, but his formulas don't return the same result as column D in your sample workbook!

[VKKT]

Greetings:

Mr. Hans Sorry for the incorrect sample.
Appreciate your continuous support.

Regards,
VKKT