Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
find (exact match) ?
i'm using the statement:
Set c = .Find(What:=Range("B" & CStr(r)).Value, LookIn:=xlValues) however, as an example, if the value i'm looking for is "Macklowe Residence", the result is being returned at the first instance of "Macklowe" (such as: "Linda Macklowe Residence"); i need to the search to find the exact match (Linda is Mr. Macklowe's mom, and we did a small project for her in the middle of the Macklowe Residence Project !!, not to confuse the 2...) thanks in advance, mark |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
find (exact match) ?
Set c = .Find(What:=Range("B" & CStr(r)).Value, _
LookIn:=xlValues, Lookat:=xlWhole) -- Regards, Tom Ogilvy "mark kubicki" wrote in message ... i'm using the statement: Set c = .Find(What:=Range("B" & CStr(r)).Value, LookIn:=xlValues) however, as an example, if the value i'm looking for is "Macklowe Residence", the result is being returned at the first instance of "Macklowe" (such as: "Linda Macklowe Residence"); i need to the search to find the exact match (Linda is Mr. Macklowe's mom, and we did a small project for her in the middle of the Macklowe Residence Project !!, not to confuse the 2...) thanks in advance, mark |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find an exact match and go to that match | Excel Discussion (Misc queries) | |||
Find Exact Match using INDEX, MATCH | Excel Worksheet Functions | |||
Find a not exact match using vlookup | Excel Discussion (Misc queries) | |||
using vlookup to find exact match | Excel Discussion (Misc queries) | |||
Find a match that;s not exact | Excel Worksheet Functions |