Retrieve data from multi-column listbox for cell or textbox

[Ron Morris]

Hi,

I have a listbox with 5 columns loaded through ADO from another workbook. I can populate a cell or textbox with the Bound column but I also want to populate a cell or textbox (haven't decided yet) with the data from column 5, based on the selection in the bound column.

I was using a Vlookup formula in a cell to retireve the data but have found a problem since the Bound column is a listing of customer names and we may have customers with multiple locations, so the Vlookup is finding the first instance and returning the wrong address, city, and account number.

How do I offset the listbox selection in the bound column to also provide me with data from the 5th column?

Thanks,

Ron