Select the UserForm then 'Run' (up the top) and click Run Sub/UserForm Test the code: Type some entries in columns A, D, and G on a spreadsheet Show the userform again, you should now see three columns of data Sample File: multi col combo box.zip 13.8KB Approved by mdmackillop.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. Used by itself, VLOOKUP will look at the first column of data in a table and bring back a value from another column on the same row.(Type, AlertStyle, Operator,Formula1, Formula2) Use the Type parameter to