To Conditions

  • Thread starter Thread starter Jeff Mackeny
  • Start date Start date
J

Jeff Mackeny

The following formula checks the value of A4 and if true enters a name in
B4, I would like to add another condition and thats true then the field
should not change regardless of whats in there already, for example the
value in A4 is true, the name 'John Doe' is entered in B2, after that I turn
on another condition and if thats true it will always leave 'John Doe' in
B2.

=IF(AND(A4=MasterList!A4,A4<>""), MasterList!B4,"")

Many thanks
 
Hi Jeff
not really sure what you're trying to do but it sounds like this is not
possible with formulas but would require VBA. Could you give a more
specific description of what you're trying to do?
 
Back
Top