I've been beaten again, the problem seems simple but obviously isn't;
I wish to enter a unique number (which has already been entered and is being used as a serial / key on a worksheet) into a text box or select it from a combobox and get returned the contents of a number of the cells within the row which the uniquet number refers to.
This seems to be exactly what I do when populating a record using VLOOKUP.
For preference I'd prefer to have this information presented in a userform to prevent my colleagues elbow typing around the worksheets.
Any guidance (even if slightly mocking as I've missed the blindingly obvious would be appreciated)