Hi, me again.
Sorry, managed to fix it, but I could do with some assistance on something else if possible.
The fix - I had a set of quotation marks missing from the named range reference, stopping the lookup, it happened when I had to add the INDIRECT reference in to the OFFSET named range.
The named range also is used with a listbox that displays a list of the contracts that match part of the input textbox. THis works great and populates the listbox properly etc, however, I want to be able to click the correct record in the listbox and this be the selected record that I want to populate TextBox1 in another userform with. So, question is, how do I take the selected item in a listbox and extract the first column data in this to populate a Textbox in another userform?
I have found a couple of solutions to this online but none work.