INDEX MATCH

Xtoph

Hi all,

I have two table. In the first table I have band names in the first column like ACDC and a contact column (where the formular should be used).
The second table will be filled via form. First column is the submitter second is free text.
If the free text is "ACD" it should match with "ACDC" and the email from submitter should appear in the second column of first table.
If Both is "ACDC" VLOOKUP or INDEX/MATCH works perfect.

Arnold A. Noche

In my experience, fuzzy searches are generally hit /miss when aiming for accuracy. If someone just typed "A", would you return "ACDC" or "Anthrax" or "A Tribe Called Quest"? I saw a recorded presentation on this buried inside Engage 2024.

Unlock precision data retrieval with INDEX, MATCH, and COLLECT

https://www.smartsheet.com/contact/ENGAGE-Seattle-2024-on-demand-sessions/video?utm_source=marketo&utm_medium=email&utm_campaign=engage-seattle-2024-post-session-content&utm_content=button1&mkt_tok=NDY0LU9OTS0xNDkAAAGW4J332vN2qIa7xE93d8XWg-XAcMRyqjl7JowKia-hgwfon1-NuTEngmM5H3y0rSWF1lEPLJI5mfP2BE-SpNWV6FNEoirgVYeMXeCYHgNxXsnZMjr2Zw