lookup multiple refs

[verlaine]

Hi,

I've a sheet with 5 columns : Numbers / Ref / Year / Month / Err Type

I would like a formula who can check in column a specific ref year month and err type and return the value that is in the cell numbers.

thsk

 

[Aladin Akyurek]

Do a search on multi-keylookup on this board.

 

[verlaine]

thanks.

I fund good examples and I'm using this forumla:

=INDEX(Erreurs_2004!$A$2:$A$1000;MATCH($A$5&CHAR(127)&$E$3&$B$5&E4;Erreurs_2004!$F$2:$F$1000;0))

just simple question.. when nothing is found the cell is #n/a .. I would like that all these cells show 0 instead of n/a.

 

[Aladin Akyurek]

thanks.

I fund good examples and I'm using this forumla:

=INDEX(Erreurs_2004!$A$2:$A$1000;MATCH($A$5&CHAR(127)&$E$3&$B$5&E4;Erreurs_2004!$F$2:$F$1000;0))

just simple question.. when nothing is found the cell is #n/a .. I would like that all these cells show 0 instead of n/a.

Use 2 cells...

In say Y2 enter:

=MATCH($A$5&CHAR(127)&$E$3&$B$5&E4;Erreurs_2004!$F$2:$F$1000;0)

In X2 enter:

=IF(ISNA(Y2);0;INDEX(Erreurs_2004!$A$2:$A$1000;Y2))

 

[verlaine]

is it possible with one cell with if(iserror ?

i was unable to make it..

 

[Aladin Akyurek]

is it possible with one cell with if(iserror ?

i was unable to make it..

See:

http://www.mrexcel.com/board2/viewtopic.php?t=62102&highlight=