Vlookup Contains Match (Google Sheets)

Job Posted: 19.11.2021 6:13:24

I have two google sheets and could use some help with a vlookup contains issue.

Sheet 1
Has a list of short product names

Sheet 2
Has a list of long product names and product names might be repeated multiple times

I want to create a vlookup on sheet 1 to tell me which products on sheet 2 contain the name of the product on sheet 1. I also want to know on sheet 1, how many times the short product name is said on sheet 2.

To start you need register at Upwork, apply now. Its free!
This and other jobs await your proposal.

Withdraw money from fiverr, upwork, freelancer, one hour translation, shuttershock, gettyimages etc with Payoneer

Get Paid Directly to Your Local Indian Bank Account in INR at Low Cost – only 2%.
Your clients can now pay you from their credit card or bank account via the Payoneer Billing Service

Register Now

Leave a Reply

Your email address will not be published. Required fields are marked *

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.