Populate listbox using vlookup or index,match?

The simplest way would be to have all your lists named, so for arguements sake create 2 comboboxes, have a list of column headers lets call them header1, header2 & header3, now have these as a named range, call them Headers, highlight the data below the first of these headings and name the range header1 do the same for the other 2. Double click the first newly created combobox and paste this in:

Please Login or Register  to view this content.

now when you change the value in the first combobox the data below the heading is available in the second!

Hope this helps.