ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   IF Statement (https://www.excelbanter.com/excel-programming/296336-if-statement.html)

Dan Van

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








All times are GMT +1. The time now is 02:18 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com