nice!!!
On Fri, Apr 3, 2009 at 8:33 PM, Alpesh Juvarewala wrote:
> Hi,
> Pls find the attached solution. The trick is to use wild card
> character. The limitation is that the text should not be repeated in
> any other cell or else the result may not be as per expectation.
>
>
>
> 2009/4/3 hari
require help on vlookup with search
option
I had not known you can add wild cards to vlookups. That is really
cool. One note of caution is that I got false positives when entering
the name George. The method stated above will display results upon
the first match, which in this case was "G
I had not known you can add wild cards to vlookups. That is really
cool. One note of caution is that I got false positives when entering
the name George. The method stated above will display results upon
the first match, which in this case was "George, Bush" and not
"George" as in Jefferson. T
Hi,
Pls find the attached solution. The trick is to use wild card
character. The limitation is that the text should not be repeated in
any other cell or else the result may not be as per expectation.
2009/4/3 hari :
> Hi All,
>
>
>
> I would require the output “city name from sheet “Data” on i