Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup, if statement, maybe an and statement | Excel Discussion (Misc queries) | |||
IF statement inside a SUMIF statement.... or alternative method | Excel Worksheet Functions | |||
Reconcile Bank statement & Credit card statement & accounting data | Excel Worksheet Functions | |||
Embedding an OR statement in an IF statement efficiently | Excel Discussion (Misc queries) | |||
appending and IF statement to an existing IF statement | Excel Worksheet Functions |