F
fruitchunk
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.
=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.