Hi,
solved your query. see the attachment.
On Fri, Feb 15, 2013 at 2:20 PM, 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 correspond
> Pooja
> Sent from BlackBerry® on Airtel
> --
> *From: * vijayajith VA
> *Sender: * excel-macros@googlegroups.com
> *Date: *Fri, 15 Feb 2013 15:08:39 +0530
> *To: *
> *ReplyTo: * excel-macros@googlegroups.com
> *Subject: *Re: $$Excel-Macros$$ Query collation of dat
-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, wrote:
> Hi All,
>
> I seek your guidance in the attached sheet, wherein, currently I am
>
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, 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
> upda
pls chk
On Fri, Feb 15, 2013 at 3:03 PM, 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.
> Therefore, plea
