This VLOOKUP tutorial looks at how to create a two way lookup to look for a value in a column, but also automatically find the column containing the value to return. (Type, AlertStyle, Operator,Formula1, Formula2) Use the Type parameter to
Use the Add method of the DataValidation property of the Range object.
