return related cell values from "search Query"

Sorry Gents

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)

Simpo