Matching Vlookup Then Give Mark "V"

[Jhon Mustofa]

hi all...

i have vlookup problem with If combine ( i think):
this situation :
1. i have 3 criteria : good, enough, excellent..
2. my target in cell F12 or H12 or J12 (depend on macthing criteria)

if the criteria matching in cell F12 or H12 or J12 fill with mark "V"

please...check this my file..

any help much appreciated..

not use macro

john m

[Root_]

Try placing the following formula in cell F12 and copying it across and down as needed:

=IF(VLOOKUP($E12,$F$4:$G$7,2,0)=G12,"V","")

[Jhon Mustofa]

hi Root...wow..excellent!!!

thank you so much..

[Root_]

You are most welcome.