I have a worksheet that has row headers with Employee numbers, salary, names
etc. I want to create a quick lookup that allows me to type in the employee
number and the resulting query will bring back all the data about that
specific employee. A quick lookup per employee. Can anyone help on what
function or how to do this? I am using Excel 2007

Many thanks.