Forum Discussion

Copper Contributor

Oct 25, 2020

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...

V lookup query.xlsx17 KB

excel

Formulas and Functions

office 365

saybhatt

Brass Contributor

Oct 25, 2020

Hi Varsit_N_Shah ,

Probably not the best approach but I used a calculated column for wild cards and then xlookup

V lookup query.xlsx12 KB

Varsit_N_Shah
Copper Contributor
Oct 25, 2020
saybhatt

Hi saybhatt

Thank you so much for the new insight. It worked but not 100%.

Varsit N. Shah
- saybhatt
  Brass Contributor
  Oct 25, 2020
  Varsit_N_Shah : Hi, in which case did the formula stand incorrect, will try to sort it out?
  - Varsit_N_Shah
    Copper Contributor
    Oct 25, 2020
    saybhatt
    
    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.
saybhatt
Brass Contributor
Oct 25, 2020
=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