vlookup / index for a large spreadsheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Thanks! That worked

Elkar said:
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
Click to expand...
 
Back
Top