Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
@IF
- Thread starter giggs11
- Start date
Using the macro language:
{IF C16#AND#@ISERR(@VLOOKUP(C15;PRODCUTcodes;0))}{ALERT "Product code required in C15";;"caution"}
The macro should all be on a single line (which can not be displayed that way here).
PRODUCTcodes is the table of allowable codes.
{IF C16#AND#@ISERR(@VLOOKUP(C15;PRODCUTcodes;0))}{ALERT "Product code required in C15";;"caution"}
The macro should all be on a single line (which can not be displayed that way here).
PRODUCTcodes is the table of allowable codes.
- Status
Similar threads
- Locked
- Question