Hi all,
I use the following formula to check if a number is in a list.
The number can be with or without a "G" infront
=IF(A3="";"";IF(ISNA(VLOOKUP(SUBSTITUTE(A3;"G";"")+0;'2016-2022'!B:B;1;FALSE));"No";"Yes"))
Now i try to rebuild this formula to show the value in column 9. If there is nothing in that column it should show "no comments"
When i use =IFERROR(VLOOKUP(A3;'2016-2022'!B:J;9;FALSE);"No comments") it works but it doesn't work if there is a G infront of the number.
Now i tried IF(A4="";"";IF(ISNA(VLOOKUP(SUBSTITUTE(A4;"G";"")+0;'2016-2022'!B:J;0;FALSE));"No comments";"") but now i get no value if there is a value in the column. It's always ""
Excel keeps going on not responding when i use xl2bb on the file.
Sorry
I use the following formula to check if a number is in a list.
The number can be with or without a "G" infront
=IF(A3="";"";IF(ISNA(VLOOKUP(SUBSTITUTE(A3;"G";"")+0;'2016-2022'!B:B;1;FALSE));"No";"Yes"))
Now i try to rebuild this formula to show the value in column 9. If there is nothing in that column it should show "no comments"
When i use =IFERROR(VLOOKUP(A3;'2016-2022'!B:J;9;FALSE);"No comments") it works but it doesn't work if there is a G infront of the number.
Now i tried IF(A4="";"";IF(ISNA(VLOOKUP(SUBSTITUTE(A4;"G";"")+0;'2016-2022'!B:J;0;FALSE));"No comments";"") but now i get no value if there is a value in the column. It's always ""
Excel keeps going on not responding when i use xl2bb on the file.
Sorry