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.

Below is the Base sheet-Sheet 1


Source
Status
Delivery
Quote status
Approval Date
INC700037568479
INC700037564386
INC700038070248
INC700037349295



Below is the RMA Sheet -Sheet 2 (Vlookup/Index match should be made from this sheet)
Status
Delivery
Quote status
Approval Date
INC700037568479
open Suspended 9/17/2015
INC700037564386
Closed 9/17/2015
INC700038070248
Suspended 9/17/2015
INC700037349295
9/17/2015