Thread: IFERROR help
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default 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.