Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Lookup cell next to data
First of all let me thank everybody that posts here. I've found alot of very useful information, but now I have a fairly simple question that I can't seem to find an answer to.
I have a workbook for keeping track of hours worked on particular jobs. Here's what I'd like to do: Sheet 1 is basically job number, job name, description of the work, and hours. (Columns A, B, C, and D respectively). Sheet 2 is a list of all of our jobs, Column A is job number, Column B is job name. Column B of Sheet 1 is all drop down menus referencing my job list (Column B) in Sheet 2. I want to be able to when I pick a name in Column B it automatically fills in the Job Number in Column A next to it. Hopefully this makes sense. I feel like it should be a simple IF, THEN function but I can't get that to work. Any help would be greatly appreciated. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup cell next to data
hi ,
put this formula in cell A2 of Sheet1 =INDEX(Sheet2!A:A,MATCH(B2,Sheet2!B:B,0)) and fill down -- isabelle Le 2012-01-09 16:49, abetancur a écrit : First of all let me thank everybody that posts here. I've found alot of very useful information, but now I have a fairly simple question that I can't seem to find an answer to. I have a workbook for keeping track of hours worked on particular jobs. Here's what I'd like to do: Sheet 1 is basically job number, job name, description of the work, and hours. (Columns A, B, C, and D respectively). Sheet 2 is a list of all of our jobs, Column A is job number, Column B is job name. Column B of Sheet 1 is all drop down menus referencing my job list (Column B) in Sheet 2. I want to be able to when I pick a name in Column B it automatically fills in the Job Number in Column A next to it. Hopefully this makes sense. I feel like it should be a simple IF, THEN function but I can't get that to work. Any help would be greatly appreciated. |
#3
|
|||
|
|||
Thank you very much Isabelle, that worked perfectly :)
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup data in multiple cell range | Excel Worksheet Functions | |||
formula to lookup data in cell NEXT to another cell | Excel Worksheet Functions | |||
Lookup vertically to next cell with data | Excel Worksheet Functions | |||
lookup column label based on data in cell | Excel Worksheet Functions | |||
The match and lookup functions can find literal data but not the same data referenced from a cell | Excel Discussion (Misc queries) |