Excel matching

[mikesal57]

I'd like to match maybe 2 or more cells to get a result from another cell...

Example:

[TABLE="width: 256"]
<tbody>[TR]
[TD="class: xl63, width: 64, align: right"]4/25[/TD]
[TD="width: 64, align: right"]4[/TD]
[TD="width: 64, align: right"]4[/TD]
[TD="width: 64, align: right"]2[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]4/25[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]4/25[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]4/25[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]4/25[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]4/26[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]4/26[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"][COLOR=#ff0000]4/26[/COLOR][/TD]
[TD="align: right"][COLOR=#ff0000]1[/COLOR][/TD]
[TD="align: right"][COLOR=#ff0000]4[/COLOR][/TD]
[TD="align: right"][COLOR=#ff0000]4[/COLOR][/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]4/26[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]4/27[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]4/27[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]4/27[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]4/27[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[/TR]
</tbody>[/TABLE]

i want to match red line A & B as criteria and pull out "D" which is 4

Thxs
Mike

 

[James006]

Hi,

Let's assume your are using cell F1 to input 4/26 and cell G1 to display 1 ...

Then you could use following array formula :

=INDEX(D1:D13,MATCH(F1&G1,A1:A13&B1:B13,0))

Hope this will help

 

[mikesal57]

Thxs James...will do

 

[James006]

Thxs James...will do

Glad you could fix your problem ... :wink:

Thanks ... for your Thanks ...