Fill Series for Lookup

S

Steve C

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:C40)
Row 2 =LOOKUP('Sheet1'!A3,'Sheet2'!B3:B41,'Sheet2'!C3:C41)

Desired result when i drag the series
Row 1 =LOOKUP('Sheet1'!A2,'Sheet2'!B2:B40,'Sheet2'!C2:C40)
Row 2 =LOOKUP('Sheet1'!A3,'Sheet2'!B2:B40,'Sheet2'!C2:C40)

thanks
 

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

Similar Threads

Lookup with multiple returns 12
Lookup and count in the same formula 1
Drag and fill from other sheets 3
Fill formula down for cells 74 rows apart 3
autoupdate data? 4
Sorting and COUNTIF 6
COUNTIF, Sorting, on Two Sheets 1
IFSUM and IFSUMS - which to use and how 4

Top