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.