Thread: IF Statement
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dan Van Dan Van is offline
external usenet poster
 
Posts: 3
Default 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