Solved Looking for advanced Vlookup

[georg0307]

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

 

[arnelgp]

maybe you can use VBA?

 

[georg0307]

Hi you are really fantastic!!! But I can try to use it in access with 2 different tables as Sheet?