VLOOKUP Function help?

Hi!

I have a spreadsheet with multiple sheets in it, and I'm having trouble with this formula, if someone can help me figure out the error? Thanks!

=IF(D41<=9),(VLOOKUP(F41,Gens,4,FALSE)),IF(((D41<=29,D41>=10)),(VLOOKUP(F41,Gens,5,FALSE)),(IF(D41=30,(VLOOKUP(F41,Gens,6,FALSE))))

Try

=VLOOKUP(F41,Gens,MATCH(D41,{0,10,30})+3,FALSE)

That worked, but how do I get it to keep the cell blank if D41 or F41 is empty?

Try

=IF(OR(D41="",F41=""),"",VLOOKUP(F41,Gens,MATCH(D41,{0,10,30})+3,FALSE))