Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fill Series for Lookup
I have a formula that uses the performance score on Sheet 1 of a workbook and
references it to a lookup to salary increase scales on Sheet 2. The formula works fine when i enter it into 1 cell, but when i try to drag the formula to fill the series in the column for the other employees, it's filling the serious for all the info in the formula including the salary scale info from Sheet 2. Is if possible to just fill the series for the performance score info from Sheet 1 and still reference the salary scales lookup from Sheet 2 or is there another formula i can use? I have thousands of employees on Sheet 1 and I'm trying to avoid having to type the formula for each one. When i drag the series Row 1 =LOOKUP('Sheet1'!A2,'Sheet2'!B2:B40,'Sheet2'!C2:C4 0) Row 2 =LOOKUP('Sheet1'!A3,'Sheet2'!B3:B41,'Sheet2'!C3:C4 1) Desired result when i drag the series Row 1 =LOOKUP('Sheet1'!A2,'Sheet2'!B2:B40,'Sheet2'!C2:C4 0) Row 2 =LOOKUP('Sheet1'!A3,'Sheet2'!B2:B40,'Sheet2'!C2:C4 0) thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fill Series for Lookup
add dollar signs
Row 1 =LOOKUP('Sheet1'!A2,'Sheet2'!B$2:B$40,'Sheet2'!C$2 :C$40) "Steve C" wrote: I have a formula that uses the performance score on Sheet 1 of a workbook and references it to a lookup to salary increase scales on Sheet 2. The formula works fine when i enter it into 1 cell, but when i try to drag the formula to fill the series in the column for the other employees, it's filling the serious for all the info in the formula including the salary scale info from Sheet 2. Is if possible to just fill the series for the performance score info from Sheet 1 and still reference the salary scales lookup from Sheet 2 or is there another formula i can use? I have thousands of employees on Sheet 1 and I'm trying to avoid having to type the formula for each one. When i drag the series Row 1 =LOOKUP('Sheet1'!A2,'Sheet2'!B2:B40,'Sheet2'!C2:C4 0) Row 2 =LOOKUP('Sheet1'!A3,'Sheet2'!B3:B41,'Sheet2'!C3:C4 1) Desired result when i drag the series Row 1 =LOOKUP('Sheet1'!A2,'Sheet2'!B2:B40,'Sheet2'!C2:C4 0) Row 2 =LOOKUP('Sheet1'!A3,'Sheet2'!B2:B40,'Sheet2'!C2:C4 0) thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fill Series for Lookup
Perfect. Much Thanks!
"Joel" wrote: add dollar signs Row 1 =LOOKUP('Sheet1'!A2,'Sheet2'!B$2:B$40,'Sheet2'!C$2 :C$40) "Steve C" wrote: I have a formula that uses the performance score on Sheet 1 of a workbook and references it to a lookup to salary increase scales on Sheet 2. The formula works fine when i enter it into 1 cell, but when i try to drag the formula to fill the series in the column for the other employees, it's filling the serious for all the info in the formula including the salary scale info from Sheet 2. Is if possible to just fill the series for the performance score info from Sheet 1 and still reference the salary scales lookup from Sheet 2 or is there another formula i can use? I have thousands of employees on Sheet 1 and I'm trying to avoid having to type the formula for each one. When i drag the series Row 1 =LOOKUP('Sheet1'!A2,'Sheet2'!B2:B40,'Sheet2'!C2:C4 0) Row 2 =LOOKUP('Sheet1'!A3,'Sheet2'!B3:B41,'Sheet2'!C3:C4 1) Desired result when i drag the series Row 1 =LOOKUP('Sheet1'!A2,'Sheet2'!B2:B40,'Sheet2'!C2:C4 0) Row 2 =LOOKUP('Sheet1'!A3,'Sheet2'!B2:B40,'Sheet2'!C2:C4 0) thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
fill series | Excel Discussion (Misc queries) | |||
Fill Series Dates: not letting me change the series from year to m | Excel Discussion (Misc queries) | |||
how to fill a different series? | Excel Worksheet Functions | |||
Edit Fill Series - How do I fill using minute increments | Excel Discussion (Misc queries) | |||
fill a particular cell on a series of worksheets from a lookup tab | Excel Discussion (Misc queries) |