That didn't work either... they all came back as n/a.

"vezerid" wrote:

Correction:

=VLOOKUP($A1,Sheet2!$A$1:$A$3415,COLUMNS($A1:B1),F ALSE)

On Oct 30, 5:37 pm, vezerid wrote:
Assuming your first formula is in Sheet1!B1, enter this formula in B1:

=VLOOKUP($A1,Sheet2!$A$1:$A$3415,COLUMNS($B1:B1),F ALSE)

It is important to add the FALSE as 4th argument to VLOOKUP.

Now you can copy the formula down and across B:F

HTH
Kostis Vezerides

On Oct 29, 10:25 pm, Ratatat
wrote:

I have 2 worksheets in the same workbook, one contains one column with 500
vendor names, the other contains over 3000, including those in the first
sheet, with mailing addresses. I need to say: If Sheet1A1 equals a cell in
Sheet 2, column A, copy B:F from that row into Sheet1. Ultimately, I need a
mailing list of the vendors in Sheet1. I've tried vlookup
{=VLOOKUP(A1,Sheet2!$A$1:$A$3415,Sheet2!B:F} but can't get it to work, I keep
getting errors (#Name?, #Ref!, etc.).