Dear All,
I am trying to find a formula similar to vertical lookup that searches for partial text in column "A" of "Foglio2". The goal is to match the partial text in column "A" of "Foglio1". I tried using the formula =CERCA.VERT(""&A2&"";Foglio1!$A$1:$D$768;2;FALSO), but it doesn't seem to work. I have attached the original file for reference.
Please note that in Italy, the formula is referred to as "CERCA.VERT" instead of "VLOOKUP". I understand that what I am asking for may be challenging, but is there a way to achieve the same result using an Access query?
Thank you for your help.
Best regards, Georg
I am trying to find a formula similar to vertical lookup that searches for partial text in column "A" of "Foglio2". The goal is to match the partial text in column "A" of "Foglio1". I tried using the formula =CERCA.VERT(""&A2&"";Foglio1!$A$1:$D$768;2;FALSO), but it doesn't seem to work. I have attached the original file for reference.
Please note that in Italy, the formula is referred to as "CERCA.VERT" instead of "VLOOKUP". I understand that what I am asking for may be challenging, but is there a way to achieve the same result using an Access query?
Thank you for your help.
Best regards, Georg