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

[Dine]

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

[SamT]

You don't need VBA, just the Worksheet Function VLOOKUP.
IF you have a VLOOKUP formula that works except that you get #NA, then edit your formula like

=IF(ISERROR(OriginalFormula),"Not Available in report",OriginalForumla)

[Dine]

Thanks Sam ...this will help.