PDA

View Full Version : multi match



JmE
01-25-2007, 11:24 AM
help needed :P
i use excel 2003...

i want to search a line in another excel file.. that 2 strings match 2 cells at the same line.. and return a text from that line (:

have only got index and match to match one string whid one cell and return data from one cell at a line. .

i hope u understand my bad english :P

Bob Phillips
01-25-2007, 11:27 AM
=INDEX(A1:A100,MATCH(1,(B1:B100="abc")*(C1:C100=123),0))

this is an array formula, so commit with Ctrl-Shift-Enter, not just Enter

JmE
01-25-2007, 05:38 PM
thanks (: works perfect :P