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