vlookup grabbing same data for each row
 

I have a very strange problem, I've never seen before. I have one
workbook, two sheets. sheet1 contains 130 employee id and name.
sheet2 has 1500 employee id numbers, with address, city, state,
zip...etc.

I need to match sheet1 with their address info from sheet2. I used:

=vlookup(a2,sheet2!a$2:k$1500,3,false)

I get what I expect, 123 Main street for the first employee id listed
in sheet1. Here's the strange part, when I drag the formula to the
bottom of the sheet, 130 rows, 123 Main Street is in each row. If I
click in a cell, say in row 10, A10 is highighted in the formula line,
when I click out of the formula line, the correct address is now lised
in A10, say, 55 South Ave.

I've checked the format of each employee id on both sheets, they are
both numbers with no decimals. Any ideas? What am I missing here?
Thanks...

vlookup grabbing same data for each row
 

On Apr 30, 11:58 am, wrote:
I have a very strange problem, I've never seen before. I have one
workbook, two sheets. sheet1 contains 130 employee id and name.
sheet2 has 1500 employee id numbers, with address, city, state,
zip...etc.

I need to match sheet1 with their address info from sheet2. I used:

=vlookup(a2,sheet2!a$2:k$1500,3,false)

I get what I expect, 123 Main street for the first employee id listed
in sheet1. Here's the strange part, when I drag the formula to the
bottom of the sheet, 130 rows, 123 Main Street is in each row. If I
click in a cell, say in row 10, A10 is highighted in the formula line,
when I click out of the formula line, the correct address is now lised
in A10, say, 55 South Ave.

I've checked the format of each employee id on both sheets, they are
both numbers with no decimals. Any ideas? What am I missing here?
Thanks...

Click Tools --Options-- select the "Calculation" tab and set the
calculation to Automatic...

vlookup grabbing same data for each row
 

On Apr 30, 12:11 pm, okrob wrote:
On Apr 30, 11:58 am, wrote:





I have a very strange problem, I've never seen before. I have one
workbook, two sheets. sheet1 contains 130 employee id and name.
sheet2 has 1500 employee id numbers, with address, city, state,
zip...etc.

I need to match sheet1 with their address info from sheet2. I used:

=vlookup(a2,sheet2!a$2:k$1500,3,false)

I get what I expect, 123 Main street for the first employee id listed
in sheet1. Here's the strange part, when I drag the formula to the
bottom of the sheet, 130 rows, 123 Main Street is in each row. If I
click in a cell, say in row 10, A10 is highighted in the formula line,
when I click out of the formula line, the correct address is now lised
in A10, say, 55 South Ave.

I've checked the format of each employee id on both sheets, they are
both numbers with no decimals. Any ideas? What am I missing here?
Thanks...

Click Tools --Options-- select the "Calculation" tab and set the
calculation to Automatic...- Hide quoted text -

- Show quoted text -

Thanks! Worked like a charm!!!!