Re: $$Excel-Macros$$ Vlookup basics and help

2012-03-08 Thread dguillett1
om: Skanda Sent: Wednesday, March 07, 2012 8:55 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Vlookup basics and help Don, It did not return any values On Wed, Mar 7, 2012 at 4:56 PM, dguillett1 wrote: Modify to suit =IF(ISNA(VLOOKUP(A26,Maindata!$A$2:$I$39,3,0)),&quo

Re: $$Excel-Macros$$ Vlookup basics and help

2012-03-07 Thread NOORAIN ANSARI
Dear Skanda, Please try it.. =IFERROR(VLOOKUP($A3,Maindata!$A$1:$I$25,MATCH(C$1,Maindata!$A$1:$I$1,0),0),"--") See attached sheet. -- Thanks & regards, Noorain Ansari *http://noorainansari.com/* *http://excelmacroworld.blogspot.com/* On Wed, Mar 7, 2012

Re: $$Excel-Macros$$ Vlookup basics and help

2012-03-07 Thread Skanda
t; dguille...@gmail.com > > *From:* Skanda > *Sent:* Wednesday, March 07, 2012 11:31 AM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Vlookup basics and help > > > > On Wed, Mar 7, 2012 at 11:04 AM, NOORAIN ANSARI > wrote: > >> Dea

Re: $$Excel-Macros$$ Vlookup basics and help

2012-03-07 Thread dguillett1
cel-Macros$$ Vlookup basics and help On Wed, Mar 7, 2012 at 11:04 AM, NOORAIN ANSARI wrote: Dear Skanda, Plase share sample workbook with group -- Thanks & regards, Noorain Ansari http://noorainansari.com/ http://excelmacroworld.blogspot.com/ On Wed, Mar 7, 2012 at 10

Re: $$Excel-Macros$$ Vlookup basics and help

2012-03-07 Thread Skanda
On Wed, Mar 7, 2012 at 11:04 AM, NOORAIN ANSARI wrote: > Dear Skanda, > > Plase share sample workbook with group > > -- > Thanks & regards, > Noorain Ansari > *http://noorainansari.com/* > *http://excelmacroworld.blogspot.com/*

Re: $$Excel-Macros$$ Vlookup basics and help

2012-03-07 Thread Skanda
Yes On Wed, Mar 7, 2012 at 11:04 AM, dguillett1 wrote: > vlookup?? > > Don Guillett > Microsoft MVP Excel > SalesAid Software > dguille...@gmail.com > > *From:* Skanda > *Sent:* Wednesday, March 07, 2012 10:53 AM > *To:* excel-macros@googlegroups.com > *S

Re: $$Excel-Macros$$ Vlookup basics and help

2012-03-07 Thread NOORAIN ANSARI
Dear Skanda, Plase share sample workbook with group -- Thanks & regards, Noorain Ansari *http://noorainansari.com/* *http://excelmacroworld.blogspot.com/* On Wed, Mar 7, 2012 at 10:23 PM, Skanda wrote: > I have two w

Re: $$Excel-Macros$$ Vlookup basics and help

2012-03-07 Thread dguillett1
vlookup?? Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Skanda Sent: Wednesday, March 07, 2012 10:53 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Vlookup basics and help I have two worksheets subset and Maindata. Subset has the following

$$Excel-Macros$$ Vlookup basics and help

2012-03-07 Thread Skanda
I have two worksheets subset and Maindata. Subset has the following field names:TDM_CL_MASTER_KEY Product Claim_Number Insured Primary_Excess Claimant Claim_Handler Maindata has the following field names:TDM_CL_MASTER_KEY Profit_Center Product Claim_Number Insured Policy_Number Primary_Exces