Prev: COUNTIFS BETWEEN WORKSHEETS HELP
Next: Count dates until complete or Cancel
From: Nadine on 2 Apr 2010 12:46
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.
From: Paul on 2 Apr 2010 12:53

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)


--
Paul

- Paul
------------------------------------------------------------------------
Paul's Profile: 1697
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=192552

http://www.thecodecage.com/forumz

From: T. Valko on 2 Apr 2010 12:59
Something like this...

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

--
Biff
Microsoft Excel MVP


"Nadine" <Nadine(a)discussions.microsoft.com> wrote in message
news:E27E6876-A37D-46D3-8692-A62C49605D88(a)microsoft.com...
>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.


From: Nadine on 2 Apr 2010 13:25
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.
From: Paul on 2 Apr 2010 13:42

Nadine;689000 Wrote:
>
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.


--
Paul

- Paul
------------------------------------------------------------------------
Paul's Profile: 1697
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=192552

http://www.thecodecage.com/forumz

 |  Next  |  Last
Pages: 1 2
Prev: COUNTIFS BETWEEN WORKSHEETS HELP
Next: Count dates until complete or Cancel