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

Paul

Hi Nadine,

Perhaps:

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

Not sure why VLOOKUP would take up more space, it's shorter.

=VLOOKUP(E1,Sheet1!$A:$H,4,0)
 
P

Paul

Never mind. I got it.


Perhaps "Thank you for your suggestions, I figured it out on my own.
Here's what I used.."? A bit late to never mind.
 
N

Nadine

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

Paul

My apologies.. I didn't realize that posts were taking anywhere fro
30-60 minutes to actually show up on the microsoft newsgroups today.
haven't posted in there in some time.

Cheers,
Paul


No one had responded when I wrote the second note. There were n
suggestions
 

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

help w indirect and index,match 3
Index / Match Formula Problem 4
Match/Index/Sum function with date range 2
Index and Match 8
index,match - how to avoid same lookup when duplicates present 1
Index Match function for lookup HELP 5
Convert Number to Text for Index/Match 1
Index Match to ignore blank cells 0

Top