IF Statement
I have the following statement and
I need to perform a function if a match is found, if no match, leave the
cell alone
RS = Application.Lookup(Range("81!F" & Z), Range("LOOKUP81!$A$1:$A$3"),
Range("LOOKUP81!$B$1:$B$3"))
if RS is true **************** Is this close ???
range("81!F" & z).value = RS
else
range("81!F" & z).value = range("81!F" & z)
end if
Thanks in advance
|