VLOOKUP with Wildcard

Hi,

Which node do I use to simulate the VLOOKUP with wildcard on KNIME i.e., VLOOKUP(A2&“*”,Sheet2!A2:A100,1,0)

I tried adding the wildcard (*) to all the values in the column using string manipulation and then use Joiner node, but that did not help…

the topics which are present in this forum related to this scenario were not helpful either… I mean the solutions of those topics got entirely deviated, because of the requirement…

my requirement is pretty much simple vlookup with wildcard.