Vlookup - VBA code

[Rbveiga]

Good afternoon,

Could you please help me?

I am interested to automatized my spreadsheet and I need a formula for Vlookup. I need to book the information "non ap" on column B without changing the "x" of colmun B

All the time which appear the information ABC123 on column "A" should appear the information "non ap". I cretaed the VBA formula, however the Vlookup is changing also the "x" from collumn "B", which I wish do not change it

A</SPAN> B</SPAN> C</SPAN> F</SPAN> ABC123</SPAN> ABC123</SPAN> non ap</SPAN> ABC123</SPAN> cde </SPAN> x</SPAN> cde </SPAN> x</SPAN> cde </SPAN> x</SPAN> ABC123</SPAN> ABC123 </SPAN>Regards, Rbveiga <TBODY> </TBODY>

<TBODY>
</TBODY>

 

[Roderick_E]

Input something like this in to column F and drag down?

=if(A2="ABC123", "non ap","")

 

[Rbveiga]

Hello Roderick

Thank you for your reply, however didn't work =(
I have the spreadsheet like below:

A</SPAN>	B</SPAN>	C</SPAN>	D</SPAN>	E</SPAN>	F</SPAN>
KREF+3003123456</SPAN>	non ap</SPAN>			KREF+300</SPAN>	non ap</SPAN>
KREF+3003987894465</SPAN>	non ap</SPAN>			BFI 000</SPAN>	non ap</SPAN>
KREF+30039879879879</SPAN>	non ap</SPAN>
123456</SPAN>	0</SPAN>
123456</SPAN>	0</SPAN>
asdfg</SPAN>	0</SPAN>
qwer</SPAN>	0</SPAN>
zxcv</SPAN>	0</SPAN>
yuiop</SPAN>	0</SPAN>
KREF+30039879879879</SPAN>	non ap</SPAN>
KREF+3003654645</SPAN>	non ap</SPAN>
KREF+30036546546</SPAN>	non ap</SPAN>
KREF+30036546546</SPAN>	non ap</SPAN>
KREF+30036546546</SPAN>	non ap</SPAN>
KREF+3003321312</SPAN>	non ap</SPAN>
BFI 00012346789</SPAN>	0</SPAN>
BFI 000123456789456</SPAN>	0</SPAN>

<TBODY>
</TBODY><COLGROUP><COL><COL span=3><COL><COL></COLGROUP>

I am using this formula: =IF(ISNA(VLOOKUP(LEFT(A:A,8),E:E:F:F,2,FALSE)),,VLOOKUP(LEFT(A:A,8),E:E:F:F,2,FALSE)), but it is not wrorking because are changing the values for 0 insted of skip ths cell and also is not pick up the other "non ap"- "BFI 000"