Replace,Find/Search,Match to extract data from combination of text and number base on list

**arman29** · 02-20-2014, 12:07 PM

Hello to all, I have attached my file: DATA123 with rules & result on it, please see the sheets. thanks
DATA123.xlsx

**bebo021999** · 02-20-2014, 12:24 PM

OK, this for all:
In B5:

Please Login or Register  to view this content.

Base on SOURCELIST, I search each item in each in DATA.
Anyway, item "2011-10-18-044" in A6 is not exist in SOURCELIST, so blank is returned. What would you like to do, return item regardless SOURCELIST, or return blank as I did?

Replace,Find/Search,Match to extract data from combination of text and number base on list

LinkBack

Thread Tools

Rate This Thread

Display

Replace,Find/Search,Match to extract data from combination of text and number base on list

Re: Replace,Find/Search,Match to extract data from combination of text and number base on

Thread Information

Users Browsing this Thread

Similar Threads

How to extract data from a daily report and match a unique tag number to a master list?

[SOLVED] VBA to Search a Text String, Find a Value listed in another column and replace the text

[SOLVED] search for text, then search for previous text, replace 1st text including number from 2nd

excel search text, find non-match words from list, display nonmatch words

[SOLVED] Search text from range of cells and base on result replace data in a different cell?

Bookmarks

Bookmarks

Posting Permissions