Vlookup giving a 0 for a blank cell, should I use an IF statment?

[Seghesio608]

Hello,
I want cells that are
>=6 to be have a "P" instead in a different worksheet
3-5 to have a "F" instead in a different worksheet
<=2 to have a "G" instead in a different worksheet

But in my worksheet I have 0 and blank cells. I need the 0 to say "G" and the blanks to remain blank. I have looked online and saw the responses and tried using an IF statement too, but I could not get it to work.

=VLOOKUP('Total Scores'!M10,Sheet3!$A$1:$B$24,2,FALSE)


With IF statement:
=IF(VLOOKUP('Total Scores'!C7,Sheet3!$A$1:$B$24,2,FALSE)=0,"",VLOOKUP('Total Scores'!C7,Sheet3!$A$1:$B$24,2,FALSE)) (Did not work)


I also tried using nested IF statements, so I could avoid Vlookup and could not get that to work either, but if someone knows/thinks that would work better, I would prefer that

Thank you so much!
Erin

 

[Aladin Akyurek]

Shouldn't you have something like:

=IF('Total Scores'!C7="","",LOOKUP('Total Scores'!C7,{0,3,6},{"G","F","P"}))

 

[RoryA]

Which version of Excel?

 

[Seghesio608]

Thank you so much! It worked great. And I am using 2010, sorry for not putting that in the original post.

 

[Aladin Akyurek]

Thank you so much! It worked great. And I am using 2010, sorry for not putting that in the original post.

You are welcome. Thanks for providing feedback.