VBA help

[Alisya]

Hi,

I am after a VBA code that will look in Col B5:B, if "N/A" found then copy the the a/c in Col C and place under the existing list in sheet "Assumptions" col C19:C and then let the user know via a msg box the new a/c ????? has been added to Assumptions.

So for the below example CITI.OPSMFI would be added to the list.

Excel Workbook
	B	C
5	Rec	Account
6	CHESS	CHES.0014074091
7	CITIINTL	CHES.0014074074
8	CITIBANK	CHES.0000927911
9	SMP	CITI.WTISII
10	LIFE EXIGO	CHES.0013667519
11	AMPLIFE INTL	CHES.0014074104
12	NOMINEE EXIGO	CHES.0014074082
13	N/A	CITI.OPSMFI
14	NZACLEAR	CITI.ICWMAM
15
16
Sheet1

 

[Alisya]

#N/A occurs when there is an error.
http://office.microsoft.com/en-us/excel-help/correct-a-n-a-error-HP005203936.aspx

It is best to get rid of the error.
May I ask which formula you are using, perhaps there is a missing reference or something.

This is the formula i am using, can i put an iserror in there?

=LOOKUP(9.99999999999999E+307,SEARCH(rngAss,C2),rngAbr)