Another simple question re: index match

[windtalkers26]

i have an excel file whose sheets are masterlist, educ_cvcr, etc.

in the masterlist sheet, in the last column it has 0-5 years old or pregnant.
i want to get rid of that because it is non sense. all i need to know now how can make work the 0-5 / pregnant column
in the btt_health sheet, where in all the beneficiaries with column pregnant = yes, will be tagged as pregnant in the btt_health sheet,
else "0 - 5" if the beneficiary is not pregnant or pregnant = "".


Thank you in advance!.

[windtalkers26]

wrong attachment. ill upload another.. sorry

[windtalkers26]

here is the correct file for my problem. thanks!

[Beamernsw]

Try this in J14 and copy down:-

=IFERROR(IF(INDEX(MASTERLIST!M:M,MATCH(F14,MASTERLIST!F:F,0))="YES","YES","0-5"),"")

[windtalkers26]

Thanks man! It worked! :P