Prev: Parse only text from column?
Next: xlookup & paste a picture
From: Chad on 1 Mar 2010 18:02
Hi

Someone was kind enough to post this custom function. What it does is
assess if a lookup is valid if it is it does one thing, if not
another.

However if I have a fomula which either the true or false component
returns an #NA then I get a #VALUE! Error. I don't want to wrap the
custom function with an if iserror formula as the idea was to make the
long formula shorter. Can someone provide some more insight?

Lookup here
=checkit(A7,VLOOKUP(A7,YesSheet!$A$2:$B$30,2,0),VLOOKUP(A7,NoSheet!$A
$2:$B$30,2,0))

Custom function here

Function Checkit(target As String, MatchResults As String,
NonMatchResults As String)

Select Case target
Case "A", "B", "C"
Checkit = MatchResults
Case Else
Checkit = NonMatchResults
End Select

End Function
 | 
Pages: 1
Prev: Parse only text from column?
Next: xlookup & paste a picture