Thread
:
IFERROR help
View Single Post
#
1
Posted to microsoft.public.excel.misc
fruitchunk
external usenet poster
Posts: 35
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.
Reply With Quote
fruitchunk
View Public Profile
Find all posts by fruitchunk