partial lookup

  1. H

    Best Match VLookup

    I have a list of hotels that I am trying to categorize by their parent company (or list as "independent"). I have a list of the names of each brand and their parent company but some hotels are iterations of the brand name ie. Courtyard Marriott (brand) but the hotel name would be Boston...
  2. R

    Partial Text Match Lookup

    I am normally able to solve these issues with some help from Google, but can't seem to find an answer for this problem. Any help would be appreciated. On one sheet I have a large amount of data containing a string of website URLs. Unfortunately the formatting of the URLs varies. On another...
  3. S

    VLOOK UP to match the cell contains separated by comma

    Hi, I have table consisting of two columns shown below, I need to match say R38 which is col 1 row 1,I want it to return 0.959901738 which is col 2, how can I do it? Using wild card I cannot match the entire R38, I will have to write only R3 which may have another value assigned elsewhere hence...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top