Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP
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. "Schmidtnikov" wrote: 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP
Schmidtnikov wrote:
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 he http://www.contextures.com/xlFunctions02.html |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP
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. "Sam Wilson" wrote: 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. "Schmidtnikov" wrote: 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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP
On Thu, 22 Oct 2009 07:17:01 -0700, Schmidtnikov
wrote: 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". |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLookUp - Does the VLookUp return the exact information? | Excel Worksheet Functions | |||
Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |