matching values between worksheets
The corrected one.
"vezerid" wrote:
Did you use the first formula I suggested or the corrected formula in
the next post?
On Oct 30, 5:57 pm, Ratatat wrote:
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 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.).
|