depending on what you are trying to do, which unfortuanately I couldn't tell
from your write up, check out advanced filter in help to see if it will do
what you want.

"Graycoast" wrote:

I have a small spread sheet where I have names in column A and various values
in columns B thru H. I need to select a value from column B, have excel
extract the data and copy and sort the names to a new column or worksheet.
I've tried Vlookup and lookup but can't get them to work right.

Is this something I'm going to have to learn VBA to do?

Thanks in advance,
Graycoast