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?
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?