I am trying to search a worksheet for a unique identifier and the extract all
of the data on that row to another worksheet. I have used and am comfortable
with VLOOKUP, but this only pulls one cell. Can this be accomplished without
using VB and if so, what is the function I can use?