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
Varsit_N_Shah : Hi, in which case did the formula stand incorrect, will try to sort it out?
Hi , I have attached file for your reference. Mainly it didn't worked at places where wild card characters are not there in the lookup value associated in lookup array.
If I understood correctly we lookup when any part of lookup value text shall met any part of the texts in lookup array. Afraid that doesn't work, bit more logic is required. For example, shall we consider GST/0650/20-21 and B2B/0650/20-21 as matched and why?
