isblank
 

=IFERROR(VLOOKUP(U4213,agt_ary!$A$2:$D$1500,2,FALS E),"Unknown ")

this is the function I am using now.
It will produce an unknow text is the data in the cell is not in the table
array.

however, for sorting porposes, if the U col is left blank it will still
produce the
unknow text,
how can I arrange this formula were if the U col data is not in the table
array
it will produce the "unkown" text, but it the col is left blank the cell
contianing the function will remail blank as well
please advise

isblank
 

Try the below ..

=IF(U4213="","",IFERROR(
VLOOKUP(U4213,agt_ary!$A$2:$D$1500,2,0),"Unknown "))

--
Jacob


" wrote:

=IFERROR(VLOOKUP(U4213,agt_ary!$A$2:$D$1500,2,FALS E),"Unknown ")

this is the function I am using now.
It will produce an unknow text is the data in the cell is not in the table
array.

however, for sorting porposes, if the U col is left blank it will still
produce the
unknow text,
how can I arrange this formula were if the U col data is not in the table
array
it will produce the "unkown" text, but it the col is left blank the cell
contianing the function will remail blank as well
please advise

isblank
 

Jacob,

Is IFERROR an XL 2007 function?

With kind regards?

JP


"Jacob Skaria" wrote in message
...
Try the below ..

=IF(U4213="","",IFERROR(
VLOOKUP(U4213,agt_ary!$A$2:$D$1500,2,0),"Unknown "))

--
Jacob


" wrote:

=IFERROR(VLOOKUP(U4213,agt_ary!$A$2:$D$1500,2,FALS E),"Unknown ")

this is the function I am using now.
It will produce an unknow text is the data in the cell is not in the
table
array.

however, for sorting porposes, if the U col is left blank it will still
produce the
unknow text,
how can I arrange this formula were if the U col data is not in the table
array
it will produce the "unkown" text, but it the col is left blank the cell
contianing the function will remail blank as well
please advise

isblank
 

Is IFERROR an XL 2007 function?

Yes

It's very useful.

Saves from having to repeat a calculation.

Prior to Excel 2007 and the IFERROR function you might do something like
this:

=IF(ISERROR(AVERAGE(A1:A10)),"",AVERAGE(A1:A10))

With IFERROR that reduces to:

=IFERROR(AVERAGE(A1:A10),"")

In prior versions, if there *isn't* an error generated then the formula has
to calculate the average twice. In Excel 2007 using IFERROR, the average
only gets calculated once.

--
Biff
Microsoft Excel MVP


"JP Ronse" wrote in message
...
Jacob,

Is IFERROR an XL 2007 function?

With kind regards?

JP


"Jacob Skaria" wrote in message
...
Try the below ..

=IF(U4213="","",IFERROR(
VLOOKUP(U4213,agt_ary!$A$2:$D$1500,2,0),"Unknown "))

--
Jacob


" wrote:

=IFERROR(VLOOKUP(U4213,agt_ary!$A$2:$D$1500,2,FALS E),"Unknown ")

this is the function I am using now.
It will produce an unknow text is the data in the cell is not in the
table
array.

however, for sorting porposes, if the U col is left blank it will still
produce the
unknow text,
how can I arrange this formula were if the U col data is not in the
table
array
it will produce the "unkown" text, but it the col is left blank the cell
contianing the function will remail blank as well
please advise

isblank
 

Thanks Biff for the follow-up
--
Jacob


"T. Valko" wrote:

Is IFERROR an XL 2007 function?

Yes

It's very useful.

Saves from having to repeat a calculation.

Prior to Excel 2007 and the IFERROR function you might do something like
this:

=IF(ISERROR(AVERAGE(A1:A10)),"",AVERAGE(A1:A10))

With IFERROR that reduces to:

=IFERROR(AVERAGE(A1:A10),"")

In prior versions, if there *isn't* an error generated then the formula has
to calculate the average twice. In Excel 2007 using IFERROR, the average
only gets calculated once.

--
Biff
Microsoft Excel MVP


"JP Ronse" wrote in message
...
Jacob,

Is IFERROR an XL 2007 function?

With kind regards?

JP


"Jacob Skaria" wrote in message
...
Try the below ..

=IF(U4213="","",IFERROR(
VLOOKUP(U4213,agt_ary!$A$2:$D$1500,2,0),"Unknown "))

--
Jacob


" wrote:

=IFERROR(VLOOKUP(U4213,agt_ary!$A$2:$D$1500,2,FALS E),"Unknown ")

this is the function I am using now.
It will produce an unknow text is the data in the cell is not in the
table
array.

however, for sorting porposes, if the U col is left blank it will still
produce the
unknow text,
how can I arrange this formula were if the U col data is not in the
table
array
it will produce the "unkown" text, but it the col is left blank the cell
contianing the function will remail blank as well
please advise





.