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
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
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.
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
-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
--
*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
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