Fwd: $$Excel-Macros$$ To seek help on writing Excel formula

& regards, *Sandeep Kumar Baranwal* Lead Solution Advisor Model validation and Valuation, Deloitte US India Gurgaon India Mob:-+91-8588802543 -- Forwarded message -- From: Sandeep Kumar Baranwal Date: Sun, Sep 11, 2016 at 6:39 PM Subject: Re: $$Excel-Macros$$ To seek he

Re: $$Excel-Macros$$ To seek help on writing Excel formula

Hi Kindly note that the match operation is to be performed basis the variable "dataset" in "Sheet1" and Variable_sheet2 in "Sheet1" should be populated using "Sheet2". Thanks & regards, *Sandeep Kumar Baranwal* Lead Solution Advisor Model validation and Valuation, Deloitte US India Gurgaon India

Re: $$Excel-Macros$$ To seek help on writing Excel formula

Is there any relation between both sheets? If yes you can use vlookup. It would be great if you can upload (attache) some sample data with your requirement -- On Fri, Sep 9, 2016 at 5:17 PM, Sandeep Kumar Baranwal < sandeepkumarbaran...@gmail.com> wrote: > Hi > > I have a spreadsheet with two t

$$Excel-Macros$$ To seek help on writing Excel formula

Hi I have a spreadsheet with two tab: Sheet1 has three variable: NameFirstNameLastName abc_xyz abc xyz rpm_xyz rpm xyz Sheet2 has one variable: Name abc_xyz rpm_xyz I need to write an excel formula in Sheet1 such that I obtain: NameFirs