PDA

View Full Version : Solved: Matched



KK1966
12-14-2009, 11:38 PM
Hi


Can someone help me formulas to matched multipart then return COL G value in the Cells M1,

Samples
Matched col A “Fcode” and col B “22” and col F “time < 15:00” which formulas can suitable for the criteria ?

Pleased + Thanks

xld
12-15-2009, 01:04 AM
Try this ARRAY formula

=INDEX(G2:G20,MATCH(1,(A2:A200="Fcode")*(B2:B200=22)*(F2:F200<"15:00"),0))

KK1966
12-15-2009, 01:36 AM
Try this ARRAY formula

=INDEX(G2:G20,MATCH(1,(A2:A200="Fcode")*(B2:B200=22)*(F2:F200<"15:00"),0))

Thanks its work