Vlookup/Index match, Vba code for two sheets in a Workbook

[Dinesh_Excel]

Hi Guys,

I am looking for some help for a simple vlookup/Indexmatch using vba code.

Below is the source Data where we do a vlookup from sheet 1(Base sheet) Sheet 2 as "RMA" .

Please note the Data are not constant ..its dynamic in nature.All the #NA should come as"Not Available in report"

Request your help for Vba code to help me in resolving my task.
Thanks Again.

 

[vletm]

@Dinesh_Excel
Something like this?
Cell[B2] is
=VLOOKUP(A2,RMA!A:B,2,0)
change to
=IFERROR(VLOOKUP(A2,RMA!A:B,2,0),"Not Available in report")
... and copy down

 

[Dinesh_Excel]

yes Friend its the same thing but this should be in a vba code.
can this be done.

 

[vletm]

@Dinesh_Excel
One possible to press Cell[C1]'s [Do it]-button

 

[Dinesh_Excel]

Superb Friend... one small change,can we get "0" Zero for the records which are in base sheet but donot have any cell value in the second sheet.

Attached sheet for your reference.

Thanks again for all your support.

I liked that part "Do it"

 

[vletm]

@Dinesh_Excel
Few 0's added, check please ...

 

[Dinesh_Excel]

Thank you Friend..it means a lot to me..

Thank you again.