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