isblank

[dlotz]

=IFERROR(VLOOKUP(U4213,agt_ary!$A$2:$D$1500,2,FALSE),"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

 

[Jacob Skaria]

Try the below ..

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

 

[JP Ronse]

Jacob,

Is IFERROR an XL 2007 function?

With kind regards?

JP

 

[T. Valko]

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.

 

[Jacob Skaria]

Thanks Biff for the follow-up
--
Jacob

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





.