numbers with a "G" infront (sometimes) leave out the G

[Bandito1]

Hello,

I use the following formula to check if numbers are in a list or not;

=IF(ISNA(VLOOKUP(K9;'2016-2022'!B:B;1;FALSE));"No";"Yes")

Sometimes the number contains a G infront. The G should not be seen.

G333114 should be 333114

But not always the G is infront.

Is there a way to add something that IF there is a G infront it should be not looked at?

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[shinigamilight]

=IFNA(VLOOKUP(M13,O1:O10,1,0),VLOOKUP("G"&M13,O1:O10,1,0))