VLOOKUP

S

Schmidtnikov

Am I going about this the wrong way....I have a sheet with a store number and
training date. I have a separate sheet with a list of employees and store
numbers. I am trying to match the training date with each employee, based on
store number.

It seems like VLOOKUP cannot reference a cell (in this case I want to use
the store number column and not manually type in each row) to then match the
store number on the other table to return the training date on the sheet with
all of the employees. Is there another way to do this?

Thanks.
 
S

Sam Wilson

If you have Sheet1 with Store number in cells A1 to A100, and training date
in B1 to B100, then in the other sheet you have employe names in Column A and
Store numbers in column B, type this in column C and copy down:

=VLOOKUP(B1,Sheet1!$A$1:$B$100,2,false)

And that should work.
 
G

Glenn

Schmidtnikov said:
Am I going about this the wrong way....I have a sheet with a store number and
training date. I have a separate sheet with a list of employees and store
numbers. I am trying to match the training date with each employee, based on
store number.

It seems like VLOOKUP cannot reference a cell (in this case I want to use
the store number column and not manually type in each row) to then match the
store number on the other table to return the training date on the sheet with
all of the employees. Is there another way to do this?

Thanks.


It would help if you posted what you have tried. Take a look here:

http://www.contextures.com/xlFunctions02.html
 
S

Schmidtnikov

Thanks Sam....that is what I thought, but I couldn't get it to work (must be
missing something). No worries, I took it into Access and all is good.
 
C

CellShocked

Am I going about this the wrong way....I have a sheet with a store number and
training date. I have a separate sheet with a list of employees and store
numbers. I am trying to match the training date with each employee, based on
store number.

It seems like VLOOKUP cannot reference a cell (in this case I want to use
the store number column and not manually type in each row) to then match the
store number on the other table to return the training date on the sheet with
all of the employees. Is there another way to do this?

Thanks.


The "store number" in the lookup table has to be the first column of
the lookup, and the looked-up value is a column count from that (the
number given)

The cell you have the formula in should be formatted "general".
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top