Forum Discussion
V-lookup function on Primary key with multiple variations
Hello Experts , I have 2 tables in my workbook. Table A has below columns. In Table A I need name of customers from Table B on the basis of Invoice Number. TABLE A Invoice no. Qty Amo...
Hi Varsit_N_Shah ,
Probably not the best approach but I used a calculated column for wild cards and then xlookup
=XLOOKUP("*"&B3&"*",$H$3:$H$14,$I$3:$I$14,"",2,1)
you can also use this directly instead of the calculated column, works the same