Index, Match help

N

Nadine

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.
 
N

Nadine

No one had responded when I wrote the second note. There were no suggestions
to thank at the time.
 

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

Excel help INDEX MATCH w/ division and subtraction 0
Index and Match 8
Array (MATCH function?) 5
VLookup takes too long 4
Index Match on Columns and Rows 0
INDEX MATCH CONCATENATE 1
VLookup vs. Match/Index 6
Adding OR to an index match formula 2

Top