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


[TABLE="width: 256"]
<TBODY>[TR]
[TD][TABLE="width: 256"]
<TBODY>[TR]
[TD]A</SPAN>
[/TD]
[TD]B</SPAN>
[/TD]
[TD]C</SPAN>
[/TD]
[TD]F</SPAN>
[/TD]
[/TR]
[TR]
[TD]ABC123</SPAN>
[/TD]
[TD][/TD]
[TD]ABC123</SPAN>
[/TD]
[TD]non ap</SPAN>
[/TD]
[/TR]
[TR]
[TD]ABC123</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]cde </SPAN>
[/TD]
[TD]x</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]cde </SPAN>
[/TD]
[TD]x</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]cde </SPAN>
[/TD]
[TD]x</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ABC123</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ABC123


</SPAN>Regards,
Rbveiga
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</TBODY>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</TBODY>[/TABLE]

 

[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:

[TABLE="width: 443"]
<TBODY>[TR]
[TD]A</SPAN>[/TD]
[TD]B</SPAN>[/TD]
[TD]C</SPAN>[/TD]
[TD]D</SPAN>[/TD]
[TD]E</SPAN>[/TD]
[TD]F</SPAN>[/TD]
[/TR]
[TR]
[TD]KREF+3003123456</SPAN>[/TD]
[TD]non ap</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]KREF+300</SPAN>[/TD]
[TD]non ap</SPAN>[/TD]
[/TR]
[TR]
[TD]KREF+3003987894465</SPAN>[/TD]
[TD]non ap</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]BFI 000</SPAN>[/TD]
[TD]non ap</SPAN>[/TD]
[/TR]
[TR]
[TD]KREF+30039879879879</SPAN>[/TD]
[TD]non ap</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]123456</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]123456</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]asdfg</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]qwer</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]zxcv</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]yuiop</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]KREF+30039879879879</SPAN>[/TD]
[TD]non ap</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]KREF+3003654645</SPAN>[/TD]
[TD]non ap</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]KREF+30036546546</SPAN>[/TD]
[TD]non ap</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]KREF+30036546546</SPAN>[/TD]
[TD]non ap</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]KREF+30036546546</SPAN>[/TD]
[TD]non ap</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]KREF+3003321312</SPAN>[/TD]
[TD]non ap</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]BFI 00012346789</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]BFI 000123456789456</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</TBODY><COLGROUP><COL><COL span=3><COL><COL></COLGROUP>[/TABLE]

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"