Dine
01-16-2016, 12:39 AM
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
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