Hi

I am trying to lookup a name for an employee ID. I have tried vlookup and
the index functions. The initial setup works; however, when I copy / paste
the function, the subsequent values for the array changes.

originial function
=INDEX(EIDs!A1:B41,MATCH(G113,EIDs!A1:A41,0),2)
function further down in spreadsheet
=INDEX(EIDs!A13:B53,MATCH(G125,EIDs!A13:A53,0),2)

I have about 6000 records I'm trying to update, it would be nice if I could
somehow keep the range the same.

Does anyone have any suggestions?

Thank you
Cynthia

Use absolute cell references for your range:

$A$1:$B$41

The $ symbol prevents Excel from incrementing the reference when the formula
is copied.

Look up Absolute and Relative cell references in Excel Help for more info on
this.

HTH,
Elkar


"Cynthia" wrote:

Hi

I am trying to lookup a name for an employee ID. I have tried vlookup and
the index functions. The initial setup works; however, when I copy / paste
the function, the subsequent values for the array changes.

originial function
=INDEX(EIDs!A1:B41,MATCH(G113,EIDs!A1:A41,0),2)
function further down in spreadsheet
=INDEX(EIDs!A13:B53,MATCH(G125,EIDs!A13:A53,0),2)

I have about 6000 records I'm trying to update, it would be nice if I could
somehow keep the range the same.

Does anyone have any suggestions?

Thank you
Cynthia

Thanks! That worked

"Elkar" wrote:

Use absolute cell references for your range:

$A$1:$B$41

The $ symbol prevents Excel from incrementing the reference when the formula
is copied.

Look up Absolute and Relative cell references in Excel Help for more info on
this.

HTH,
Elkar


"Cynthia" wrote:

Hi

I am trying to lookup a name for an employee ID. I have tried vlookup and
the index functions. The initial setup works; however, when I copy / paste
the function, the subsequent values for the array changes.

originial function
=INDEX(EIDs!A1:B41,MATCH(G113,EIDs!A1:A41,0),2)
function further down in spreadsheet
=INDEX(EIDs!A13:B53,MATCH(G125,EIDs!A13:A53,0),2)

I have about 6000 records I'm trying to update, it would be nice if I could
somehow keep the range the same.

Does anyone have any suggestions?

Thank you
Cynthia