Multiple cell value

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

IP - 07 May 2008 22:53 GMT

I am using a formula and it has 2 or 3 different cells, it like as follow:
cell A1: January, A2:CH
now I want to take a formula to use those two cells as a combine like,
Index($B4:$I9000,Match(cell("contents",$A$2),$B$4:$B$9000,0),2) --this is my
original formula now I want to change and put down a two matching cells like
A1 and A2 in the formula... How can I do this?

Reply to this Message

Dave Peterson - 08 May 2008 00:38 GMT

How about:

=INDEX($C4:$C9000,MATCH(1,($A$1=$A$4:$A$9000)*($A$2=$B$4:$B$9000),0))

This is an array formula. Hit ctrl-shift-enter instead of enter. If you do it
correctly, excel will wrap curly brackets {} around your formula. (don't type
them yourself.)

Adjust the range to match--but you can only use the whole column in xl2007.

I'm retrieving the value from column C (instead of specifying a column in B:I)

And I'm looking for the first row that has a match in A4:A9000 to A1 and at the
same time a match in B4:B9000 to A2.

These portions:
($A$1=$A$4:$A$9000)
and
($A$2=$B$4:$B$9000)

Each return a bunch of true/false--depending on the match.

But when they're multiplied using:
($A$1=$A$4:$A$9000)*($A$2=$B$4:$B$9000)

That bunch of true/falses becomes a bunch of 1's and 0's.
(true*true = 1, false*anything = 0)

> I am using a formula and it has 2 or 3 different cells, it like as follow:
> cell A1: January, A2:CH
> now I want to take a formula to use those two cells as a combine like,
> Index($B4:$I9000,Match(cell("contents",$A$2),$B$4:$B$9000,0),2) --this is my
> original formula now I want to change and put down a two matching cells like
> A1 and A2 in the formula... How can I do this?

Signature

Dave Peterson

Reply to this Message

ip2010@gmail.com - 10 May 2008 16:02 GMT

> How about:
>
[quoted text clipped - 34 lines]
>
> Dave Peterson

I can try it on Monday, cause this is for my work which I am working
for and I don't have a access to communicate, so I will try on Monday
then I can answer you is that working or not, but thanks for answer...

Reply to this Message

ip2010@gmail.com - 13 May 2008 00:34 GMT

On May 10, 10:02 am, ip2...@gmail.com wrote:

> > How about:
>
[quoted text clipped - 38 lines]
> for and I don't have a access to communicate, so I will try on Monday
> then I can answer you is that working or not, but thanks for answer...

Hi Dave,
It is not working...
Actually let me show you a proper way what I am doing...
Here is my example:
A:_______
B:_______
C:_______

1 2 3
4 5 6
January 74 256
1260 565 and so on
January 75 1560
120 ....
January 76
1820 978 888
January 102
January 603 2250 5678
3345 and so on
.
.
.
February 74 could be any number
February 75
February 76
Feb 102
.
.
.
March 74
March 75
.
.
.
Any month

Now I want to get a month (any from the list), 2 from list and 3, 4, 5
from the list...
That's what I am trying to do this.

If I use a same formula it is giving (my formula) me answer from one
thing only (any one from A, B or C), but I want to match that with A
and B or C, so I want in 2 cells which would be any A and B or C...
Hope you understand my question...
Thank you for taking a time...

Reply to this Message

Dave Peterson - 13 May 2008 01:35 GMT

I don't understand.

Maybe you can explain again or someone else will chime in.

> On May 10, 10:02 am, ip2...@gmail.com wrote:
> >
[quoted text clipped - 86 lines]
> Hope you understand my question...
> Thank you for taking a time...

Signature

Dave Peterson

Reply to this Message

ip2010@gmail.com - 13 May 2008 03:46 GMT

> I don't understand.
>
[quoted text clipped - 96 lines]
>
> Dave Peterson

Please check your email I emailed you my question and a example
spreadsheet.

Reply to this Message

Dave Peterson - 13 May 2008 12:52 GMT

Please keep the discussion in the newsgroups.

You'll find that you have lots more potential responders.

<snipped>

> Please check your email I emailed you my question and a example
> spreadsheet.

Signature

Dave Peterson

Reply to this Message