SueB,
I think dan dungan has probably given you the fix you need. I suspect that
in your original VLOOKUP() you probably didn't reference the entire matrix.
You may have written something like:
=VLOOKUP(Sheet1!A1,Sheet1!$A$1:B$6,2,False)
That would work to just pick up values from column B in the matrix, but you
could not set the column reference (,2,) to any number greater than that
because you have only referenced 2 columns in the matrix. Notice that in
dan's formulas, he referenced all the way over to column F, so he can use any
number from 1 to 6 to get the information from the various columns in it,
since it has 6 columns in the matrix.

"SueB" wrote:

I have worksheet A with 5 columns of information and 10 rows.

I have worksheet B with just one column of information and multiple rows.

Column A in both worksheets are codes.

I want to do a function that will look at col A, find the match to it on
worksheet B and then return columns B-G on the same line that it matched
column A on.

I know this sounds fuzzy but I can return one value (i.e. column B2, but not
columns b2 through 6g

Any help would be terrific. I tried to use the vlookup function but got
messed up when I went to reference columns b through g.

Thank you!

Susan