Index, Match help
 

I need help with an index, match formula.

Worksheet 1 has 8 columns. In ColA is the name, Col 4 is the associated
cost center.
Worksheet 2 needs to find the cost center based on the name in ColE.
I could use a vlookup but the Index Match takes up less space when saved. I
am using Excel 2003. Thanks.

Index, Match help
 

Something like this...

=INDEX(Sheet1!D:D,MATCH(E1,Sheet1!A:A,0))

--
Biff
Microsoft Excel MVP


"Nadine" wrote in message
...
I need help with an index, match formula.

Worksheet 1 has 8 columns. In ColA is the name, Col 4 is the associated
cost center.
Worksheet 2 needs to find the cost center based on the name in ColE.
I could use a vlookup but the Index Match takes up less space when saved.
I
am using Excel 2003. Thanks.

Index, Match help
 

Never mind. I got it.

"Nadine" wrote:

I need help with an index, match formula.

Worksheet 1 has 8 columns. In ColA is the name, Col 4 is the associated
cost center.
Worksheet 2 needs to find the cost center based on the name in ColE.
I could use a vlookup but the Index Match takes up less space when saved. I
am using Excel 2003. Thanks.