IFERROR help
 

This is the current formula I have
=IF(A1="NEW","",LOOKUP(2,1/((B1=Sheet1!A:A)*(C1=Sheet1!F:F)),Sheet1!K:K))
on some cells I get n/a
I want to combine it with IFERROR function but i don't know how.

IFERROR help
 

I don't have XL2007, but I think the syntax is:

=IFERROR(your_formula,"")

where I presume you want a blank to show instead of #N/A.

Hope this helps.

Pete

On Sep 1, 11:15*pm, fruitchunk
wrote:
This is the current formula I have
=IF(A1="NEW","",LOOKUP(2,1/((B1=Sheet1!A:A)*(C1=Sheet1!F:F)),Sheet1!K:K))
on some cells I get n/a
I want to combine it with IFERROR function but i don't know how.

IFERROR help
 

Assuming you want to check for an error in the Lookup function, is would be:
=IF(A1="NEW","",IFERROR(LOOKUP(2,1/((B1=Sheet1!A:A)*(C1=Sheet1!F:F)),Sheet1!K:K),"Err or
message"))

Regards,
Fred

"fruitchunk" wrote in message
...
This is the current formula I have
=IF(A1="NEW","",LOOKUP(2,1/((B1=Sheet1!A:A)*(C1=Sheet1!F:F)),Sheet1!K:K))
on some cells I get n/a
I want to combine it with IFERROR function but i don't know how.