Vlookup using Vba code across two tabs

[Dinesh_Excel]

Hi Friends

I am trying to implement the excel vlookup function into my vba command.
I have a sheet with 2 tabs :

Tab 1 = "Base sheet" has 3 columns
Tab 2 = "ottwafield" has 2 columns.

We have to do a vlookup from Tab 1 to Tab 2 to get the data points from Tab 2.

Tab 1




Tab 2

 

[jindon]

Not sure if this is how you wanted.

Sub test()
    Range("a2", Range("a" & Rows.Count).End(xlUp)).Columns("ae:af").Formula = _
    "=iferror(vlookup($a2,ottwafield!$a:$b,column(a1),false),"""")"
End Sub

 

[Dinesh_Excel]

Thanks Jindon...a very small change, for all the false cases can we get "#NA" instead of Blanks.

Thank you for your uncondtional help

 

[jindon]

Just delete IfError function....
change

"=iferror(vlookup($a2,ottwafield!$a:$b,column(a1),false),"""")"

to

"=vlookup($a2,ottwafield!$a:$b,column(a1),false)"

 

[Dinesh_Excel]

Thanks Jindon...its working fine now.
Appreciate your help as always.

it was very helpful.

 

[jindon]

You are welcome and thanks for the feedback.