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

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

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