Partial match v-look up

**Jacks18928** · 01-12-2019, 03:15 AM

Hello all,

I am trying to do a partial match against a data table but struggling to get it to work

I have attached an excel doc example

Thanks in advance

**BadlySpelledBuoy** · 01-12-2019, 03:34 AM

What are your expected results?

BSB

**BadlySpelledBuoy** · 01-12-2019, 03:51 AM

Purely guessing at your expected outcome, but try this in G2 and copy down:

Formula:

Please Login or Register  to view this content.

BSB

**Jacks18928** · 01-12-2019, 01:20 PM

that formula is perfect, thanks for you help with this one

Partial match v-look up

LinkBack

Thread Tools

Rate This Thread

Display

Partial match v-look up

Re: Partial match v-look up

Re: Partial match v-look up

Re: Partial match v-look up

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Lookup partial values and if match return partial value from another cell

Matching partial text to partial text - is this possible?

[SOLVED] Match partial text when partial text is not exact

[SOLVED] need to do Partial name search and return the value against the partial name

Partial duplicates: is it possible to specify which partial duplicates to delete?

Help Converting Partial Text, Partial Number Cells to Number Only

matching partial text within one cell to partial text within another

Bookmarks

Bookmarks

Posting Permissions