Fred

The function doesn't appear to be working. I keep getting undefined

Function, but I've created the module and saved it as you posted.

No. I need this to be automated. There will be a field called hier

containing different values, ex nick, mabn, etal, etc. I need to be able to

search another field, hier2 to see if these are located in there, perphaps

like [hier]*. But when the find that value in hier 2 will place the hier

value in the new created field.

containing different values, ex nick, mabn, etal, etc. I need to be able to

search another field, hier2 to see if these are located in there, perphaps

like [hier]*. But when the find that value in hier 2 will place the hier

value in the new created field.

actually Fred he code somewhat works, except when it searches for the value

it has to be in the beinning of the value of the other field. Also returning

Null values even when I put criteria "is not null" Its returning with results

such as: Searching for GON, returns BRGOD, RAXGON, and GOBAC. It should only

return with GOBAC.

it has to be in the beinning of the value of the other field. Also returning

Null values even when I put criteria "is not null" Its returning with results

such as: Searching for GON, returns BRGOD, RAXGON, and GOBAC. It should only

return with GOBAC.

1. Find Method for finding the next value in a range GT certain value

2. Finding the Value (of text and numbers) between N/A's

4. .find not finding corect value

5. Find multiple characters in one find using MSword find/replace

6. Find matching values, copy/paste values as well as values in ColA

7. formula- find min value in range, then average that value with one value on each side

8. Find matching values, copy/paste values as well as values in C

9. Find a textstring in a "Range" - and then return a value if textstring is found.

10. Find and Delete a specified value IF found in cell in ANY Sheets in a WorkBook

11. Need to find particular string within cell text, if found a value is copied

12. Find Method for finding the next value in a range GT certain v

13. find last row value in column when using MATCH to find column

14. FIND function to find a range of values?

15. Find and replace using values calculated from the found string

3 post • Page:**1** of **1**