Help embedding vlookup in if formula

[greygrendon]

Good Evening

I'm trying to use an IF formula with an embedded VLOOKUP formula. I need the formula to search the grid for a specific term, and if it matches, use the VLOOKUP. However, if it doesn't match any of the terms, I want it to match the original term it was looking for. The formula i'm trying to use is below - it works for the VLOOKUPS but not if the search term isnt in the grid... then I get an #n/a

=IF(G11="Q10:Q13","G13",VLOOKUP(G11,Q$10:R$13,2,0))

Any help would be great!!!

Cheers

 

[rpaulson]

Try:

=iferror(vlookup(g11,$q$10:$r$13,2,0),g11)

 

[greygrendon]

Worked great - thanks for the help!