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
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
Try this ARRAY formula
=INDEX(G2:G20,MATCH(1,(A2:A200="Fcode")*(B2:B200=22)*(F2:F200<"15:00"),0))
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Thanks its workOriginally Posted by xld
Posting Permissions
Reply With Quote
