$$Excel-Macros$$ Query collation of data ignoring #n/a

2013-02-15 Thread vatspoojavats
Hi All, I seek your guidance in the attached sheet, wherein, currently I am updating manually the column: I Correct Cost Centre Contracts.I am updating this from the data available in corresponding columns: D,E,F G. Therefore, please guide with a formula which can extract the required data by

$$Excel-Macros$$ Query collation of data ignoring #n/a

2013-02-15 Thread vatspoojavats
Hi All, I seek your guidance in the attached sheet, wherein, currently I am updating manually the column: I Correct Cost Centre Contracts.I am updating this from the data available in corresponding columns: D,E,F G. Therefore, please guide with a formula which can extract the required data by

Re: $$Excel-Macros$$ Query collation of data ignoring #n/a

2013-02-15 Thread Dhaval Shah
pls chk On Fri, Feb 15, 2013 at 3:03 PM, vatspoojav...@gmail.com wrote: Hi All, I seek your guidance in the attached sheet, wherein, currently I am updating manually the column: I Correct Cost Centre Contracts.I am updating this from the data available in corresponding columns: D,E,F G.

Re: $$Excel-Macros$$ Query collation of data ignoring #n/a

2013-02-15 Thread vijayajith VA
Hi =IFERROR(VLOOKUP(A2,'Cost Center1'!$A$2:$A$21,1,0), ) .if you want blank in place of N/A On Fri, Feb 15, 2013 at 2:20 PM, vatspoojav...@gmail.com wrote: Hi All, I seek your guidance in the attached sheet, wherein, currently I am updating manually the column: I Correct Cost Centre

Re: $$Excel-Macros$$ Query collation of data ignoring #n/a

2013-02-15 Thread vatspoojavats
-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Query collation of data ignoring #n/a Hi =IFERROR(VLOOKUP(A2,'Cost Center1'!$A$2:$A$21,1,0), ) .if you want blank in place of N/A On Fri, Feb 15, 2013 at 2:20 PM, vatspoojav...@gmail.com wrote: Hi All, I seek your guidance

Re: $$Excel-Macros$$ Query collation of data ignoring #n/a

2013-02-15 Thread vijayajith VA
-- *From: * vijayajith VA vijayajith...@gmail.com *Sender: * excel-macros@googlegroups.com *Date: *Fri, 15 Feb 2013 15:08:39 +0530 *To: *excel-macros@googlegroups.com *ReplyTo: * excel-macros@googlegroups.com *Subject: *Re: $$Excel-Macros$$ Query collation of data ignoring #n

Re: $$Excel-Macros$$ Query collation of data ignoring #n/a

2013-02-15 Thread Ms Excel user
Hi, solved your query. see the attachment. On Fri, Feb 15, 2013 at 2:20 PM, vatspoojav...@gmail.com wrote: Hi All, I seek your guidance in the attached sheet, wherein, currently I am updating manually the column: I Correct Cost Centre Contracts.I am updating this from the data