Is this possible please if so How. Thankyou.

Hi!

>so cell A1 ="ADDISON Mark James"

=VLOOKUP(F6,$U$2:$Z$2000,2,0)&" "&VLOOKUP(F6,$U$2:$Z$2000,3,0)

> so cell A1 ="ADDISON
> Mark James" (Wrap Check box ticked)

=VLOOKUP(F6,$U$2:$Z$2000,2,0)&CHAR(10)&VLOOKUP(F6,$U$2:$Z$2000,3,0)

Biff

"Steved" <[email protected]> wrote in message
news:[email protected]...
> Hello from Steved
>
> Cell A1 =VLOOKUP(F6,$U$2:$Z$2000,2,0) will get the Surname ie "ADDISON"
> Cell B1=VLOOKUP(F6,$U$2:$Z$2000,3,0) will get the first Names ie "Mark
> James"
>
> Ok can I get the formula to combine the both to get = "ADDISON Mark James"
>
> so cell A1 ="ADDISON Mark James"
> or
> so cell A1 ="ADDISON
> Mark James" (Wrap Check box ticked)
>
> Thankyou.
>
>
>

Hello Biff from Steved

Can I impose please and ask you to take it one more stage and that is #N/A
be blank.

Thanks.

"Biff" wrote:

> Hi!
>
> >so cell A1 ="ADDISON Mark James"
>
> =VLOOKUP(F6,$U$2:$Z$2000,2,0)&" "&VLOOKUP(F6,$U$2:$Z$2000,3,0)
>
> > so cell A1 ="ADDISON
> > Mark James" (Wrap Check box ticked)
>
> =VLOOKUP(F6,$U$2:$Z$2000,2,0)&CHAR(10)&VLOOKUP(F6,$U$2:$Z$2000,3,0)
>
> Biff
>
> "Steved" <[email protected]> wrote in message
> news:[email protected]...
> > Hello from Steved
> >
> > Cell A1 =VLOOKUP(F6,$U$2:$Z$2000,2,0) will get the Surname ie "ADDISON"
> > Cell B1=VLOOKUP(F6,$U$2:$Z$2000,3,0) will get the first Names ie "Mark
> > James"
> >
> > Ok can I get the formula to combine the both to get = "ADDISON Mark James"
> >
> > so cell A1 ="ADDISON Mark James"
> > or
> > so cell A1 ="ADDISON
> > Mark James" (Wrap Check box ticked)
> >
> > Thankyou.
> >
> >
> >
>
>
>

It's ok I looked up and found away

=IF(ISNA(VLOOKUP(F6,$U$2:$Z$2000,2,0)&CHAR(10)&VLOOKUP(F6,$U$2:$Z$2000,3,0)),"",VLOOKUP(F6,$U$2:$Z$2000,2,0)&CHAR(10)&VLOOKUP(F6,$U$2:$Z$2000,3,0))

Thankyou.

"Steved" wrote:

> Hello Biff from Steved
>
> Can I impose please and ask you to take it one more stage and that is #N/A
> be blank.
>
> Thanks.
>
> "Biff" wrote:
>
> > Hi!
> >
> > >so cell A1 ="ADDISON Mark James"
> >
> > =VLOOKUP(F6,$U$2:$Z$2000,2,0)&" "&VLOOKUP(F6,$U$2:$Z$2000,3,0)
> >
> > > so cell A1 ="ADDISON
> > > Mark James" (Wrap Check box ticked)
> >
> > =VLOOKUP(F6,$U$2:$Z$2000,2,0)&CHAR(10)&VLOOKUP(F6,$U$2:$Z$2000,3,0)
> >
> > Biff
> >
> > "Steved" <[email protected]> wrote in message
> > news:[email protected]...
> > > Hello from Steved
> > >
> > > Cell A1 =VLOOKUP(F6,$U$2:$Z$2000,2,0) will get the Surname ie "ADDISON"
> > > Cell B1=VLOOKUP(F6,$U$2:$Z$2000,3,0) will get the first Names ie "Mark
> > > James"
> > >
> > > Ok can I get the formula to combine the both to get = "ADDISON Mark James"
> > >
> > > so cell A1 ="ADDISON Mark James"
> > > or
> > > so cell A1 ="ADDISON
> > > Mark James" (Wrap Check box ticked)
> > >
> > > Thankyou.
> > >
> > >
> > >
> >
> >
> >

=IF(ISNUMBER(MATCH(F6,$U$2:$U$2000,0)),VLOOKUP(F6,$U$2:$Z$2000,2,0)&"
"&VLOOKUP(F6,$U$2:$Z$2000,3,0),"")

Steved wrote:
> Hello Biff from Steved
>
> Can I impose please and ask you to take it one more stage and that is #N/A
> be blank.
>
> Thanks.
>
> "Biff" wrote:
>
>
>>Hi!
>>
>>
>>>so cell A1 ="ADDISON Mark James"
>>
>>=VLOOKUP(F6,$U$2:$Z$2000,2,0)&" "&VLOOKUP(F6,$U$2:$Z$2000,3,0)
>>
>>
>>>so cell A1 ="ADDISON
>>> Mark James" (Wrap Check box ticked)
>>
>>=VLOOKUP(F6,$U$2:$Z$2000,2,0)&CHAR(10)&VLOOKUP(F6,$U$2:$Z$2000,3,0)
>>
>>Biff
>>
>>"Steved" <[email protected]> wrote in message
>>news:[email protected]...
>>
>>>Hello from Steved
>>>
>>>Cell A1 =VLOOKUP(F6,$U$2:$Z$2000,2,0) will get the Surname ie "ADDISON"
>>>Cell B1=VLOOKUP(F6,$U$2:$Z$2000,3,0) will get the first Names ie "Mark
>>>James"
>>>
>>>Ok can I get the formula to combine the both to get = "ADDISON Mark James"
>>>
>>>so cell A1 ="ADDISON Mark James"
>>>or
>>>so cell A1 ="ADDISON
>>> Mark James" (Wrap Check box ticked)
>>>
>>>Thankyou.
>>>
>>>
>>>
>>
>>
>>

--

[1] The SumProduct function should implicitly coerce the truth values to
their Excel numeric equivalents.
[2] The lookup functions should have an optional argument for the return
value, defaulting to #N/A in its absence.

Hello aladin from Steved

Yes much clearner Thankyou.

"Aladin Akyurek" wrote:

>
> =IF(ISNUMBER(MATCH(F6,$U$2:$U$2000,0)),VLOOKUP(F6,$U$2:$Z$2000,2,0)&"
> "&VLOOKUP(F6,$U$2:$Z$2000,3,0),"")
>
> Steved wrote:
> > Hello Biff from Steved
> >
> > Can I impose please and ask you to take it one more stage and that is #N/A
> > be blank.
> >
> > Thanks.
> >
> > "Biff" wrote:
> >
> >
> >>Hi!
> >>
> >>
> >>>so cell A1 ="ADDISON Mark James"
> >>
> >>=VLOOKUP(F6,$U$2:$Z$2000,2,0)&" "&VLOOKUP(F6,$U$2:$Z$2000,3,0)
> >>
> >>
> >>>so cell A1 ="ADDISON
> >>> Mark James" (Wrap Check box ticked)
> >>
> >>=VLOOKUP(F6,$U$2:$Z$2000,2,0)&CHAR(10)&VLOOKUP(F6,$U$2:$Z$2000,3,0)
> >>
> >>Biff
> >>
> >>"Steved" <[email protected]> wrote in message
> >>news:[email protected]...
> >>
> >>>Hello from Steved
> >>>
> >>>Cell A1 =VLOOKUP(F6,$U$2:$Z$2000,2,0) will get the Surname ie "ADDISON"
> >>>Cell B1=VLOOKUP(F6,$U$2:$Z$2000,3,0) will get the first Names ie "Mark
> >>>James"
> >>>
> >>>Ok can I get the formula to combine the both to get = "ADDISON Mark James"
> >>>
> >>>so cell A1 ="ADDISON Mark James"
> >>>or
> >>>so cell A1 ="ADDISON
> >>> Mark James" (Wrap Check box ticked)
> >>>
> >>>Thankyou.
> >>>
> >>>
> >>>
> >>
> >>
> >>
>
> --
>
> [1] The SumProduct function should implicitly coerce the truth values to
> their Excel numeric equivalents.
> [2] The lookup functions should have an optional argument for the return
> value, defaulting to #N/A in its absence.
>

Hi!

>so cell A1 ="ADDISON Mark James"

=VLOOKUP(F6,$U$2:$Z$2000,2,0)&" "&VLOOKUP(F6,$U$2:$Z$2000,3,0)

> so cell A1 ="ADDISON
> Mark James" (Wrap Check box ticked)

=VLOOKUP(F6,$U$2:$Z$2000,2,0)&CHAR(10)&VLOOKUP(F6,$U$2:$Z$2000,3,0)

Biff

"Steved" <[email protected]> wrote in message
news:[email protected]...
> Hello from Steved
>
> Cell A1 =VLOOKUP(F6,$U$2:$Z$2000,2,0) will get the Surname ie "ADDISON"
> Cell B1=VLOOKUP(F6,$U$2:$Z$2000,3,0) will get the first Names ie "Mark
> James"
>
> Ok can I get the formula to combine the both to get = "ADDISON Mark James"
>
> so cell A1 ="ADDISON Mark James"
> or
> so cell A1 ="ADDISON
> Mark James" (Wrap Check box ticked)
>
> Thankyou.
>
>
>

Hello Biff from Steved

Can I impose please and ask you to take it one more stage and that is #N/A
be blank.

Thanks.

"Biff" wrote:

> Hi!
>
> >so cell A1 ="ADDISON Mark James"
>
> =VLOOKUP(F6,$U$2:$Z$2000,2,0)&" "&VLOOKUP(F6,$U$2:$Z$2000,3,0)
>
> > so cell A1 ="ADDISON
> > Mark James" (Wrap Check box ticked)
>
> =VLOOKUP(F6,$U$2:$Z$2000,2,0)&CHAR(10)&VLOOKUP(F6,$U$2:$Z$2000,3,0)
>
> Biff
>
> "Steved" <[email protected]> wrote in message
> news:[email protected]...
> > Hello from Steved
> >
> > Cell A1 =VLOOKUP(F6,$U$2:$Z$2000,2,0) will get the Surname ie "ADDISON"
> > Cell B1=VLOOKUP(F6,$U$2:$Z$2000,3,0) will get the first Names ie "Mark
> > James"
> >
> > Ok can I get the formula to combine the both to get = "ADDISON Mark James"
> >
> > so cell A1 ="ADDISON Mark James"
> > or
> > so cell A1 ="ADDISON
> > Mark James" (Wrap Check box ticked)
> >
> > Thankyou.
> >
> >
> >
>
>
>

It's ok I looked up and found away

=IF(ISNA(VLOOKUP(F6,$U$2:$Z$2000,2,0)&CHAR(10)&VLOOKUP(F6,$U$2:$Z$2000,3,0)),"",VLOOKUP(F6,$U$2:$Z$2000,2,0)&CHAR(10)&VLOOKUP(F6,$U$2:$Z$2000,3,0))

Thankyou.

"Steved" wrote:

> Hello Biff from Steved
>
> Can I impose please and ask you to take it one more stage and that is #N/A
> be blank.
>
> Thanks.
>
> "Biff" wrote:
>
> > Hi!
> >
> > >so cell A1 ="ADDISON Mark James"
> >
> > =VLOOKUP(F6,$U$2:$Z$2000,2,0)&" "&VLOOKUP(F6,$U$2:$Z$2000,3,0)
> >
> > > so cell A1 ="ADDISON
> > > Mark James" (Wrap Check box ticked)
> >
> > =VLOOKUP(F6,$U$2:$Z$2000,2,0)&CHAR(10)&VLOOKUP(F6,$U$2:$Z$2000,3,0)
> >
> > Biff
> >
> > "Steved" <[email protected]> wrote in message
> > news:[email protected]...
> > > Hello from Steved
> > >
> > > Cell A1 =VLOOKUP(F6,$U$2:$Z$2000,2,0) will get the Surname ie "ADDISON"
> > > Cell B1=VLOOKUP(F6,$U$2:$Z$2000,3,0) will get the first Names ie "Mark
> > > James"
> > >
> > > Ok can I get the formula to combine the both to get = "ADDISON Mark James"
> > >
> > > so cell A1 ="ADDISON Mark James"
> > > or
> > > so cell A1 ="ADDISON
> > > Mark James" (Wrap Check box ticked)
> > >
> > > Thankyou.
> > >
> > >
> > >
> >
> >
> >

=IF(ISNUMBER(MATCH(F6,$U$2:$U$2000,0)),VLOOKUP(F6,$U$2:$Z$2000,2,0)&"
"&VLOOKUP(F6,$U$2:$Z$2000,3,0),"")

Steved wrote:
> Hello Biff from Steved
>
> Can I impose please and ask you to take it one more stage and that is #N/A
> be blank.
>
> Thanks.
>
> "Biff" wrote:
>
>
>>Hi!
>>
>>
>>>so cell A1 ="ADDISON Mark James"
>>
>>=VLOOKUP(F6,$U$2:$Z$2000,2,0)&" "&VLOOKUP(F6,$U$2:$Z$2000,3,0)
>>
>>
>>>so cell A1 ="ADDISON
>>> Mark James" (Wrap Check box ticked)
>>
>>=VLOOKUP(F6,$U$2:$Z$2000,2,0)&CHAR(10)&VLOOKUP(F6,$U$2:$Z$2000,3,0)
>>
>>Biff
>>
>>"Steved" <[email protected]> wrote in message
>>news:[email protected]...
>>
>>>Hello from Steved
>>>
>>>Cell A1 =VLOOKUP(F6,$U$2:$Z$2000,2,0) will get the Surname ie "ADDISON"
>>>Cell B1=VLOOKUP(F6,$U$2:$Z$2000,3,0) will get the first Names ie "Mark
>>>James"
>>>
>>>Ok can I get the formula to combine the both to get = "ADDISON Mark James"
>>>
>>>so cell A1 ="ADDISON Mark James"
>>>or
>>>so cell A1 ="ADDISON
>>> Mark James" (Wrap Check box ticked)
>>>
>>>Thankyou.
>>>
>>>
>>>
>>
>>
>>

--

[1] The SumProduct function should implicitly coerce the truth values to
their Excel numeric equivalents.
[2] The lookup functions should have an optional argument for the return
value, defaulting to #N/A in its absence.

Hello aladin from Steved

Yes much clearner Thankyou.

"Aladin Akyurek" wrote:

>
> =IF(ISNUMBER(MATCH(F6,$U$2:$U$2000,0)),VLOOKUP(F6,$U$2:$Z$2000,2,0)&"
> "&VLOOKUP(F6,$U$2:$Z$2000,3,0),"")
>
> Steved wrote:
> > Hello Biff from Steved
> >
> > Can I impose please and ask you to take it one more stage and that is #N/A
> > be blank.
> >
> > Thanks.
> >
> > "Biff" wrote:
> >
> >
> >>Hi!
> >>
> >>
> >>>so cell A1 ="ADDISON Mark James"
> >>
> >>=VLOOKUP(F6,$U$2:$Z$2000,2,0)&" "&VLOOKUP(F6,$U$2:$Z$2000,3,0)
> >>
> >>
> >>>so cell A1 ="ADDISON
> >>> Mark James" (Wrap Check box ticked)
> >>
> >>=VLOOKUP(F6,$U$2:$Z$2000,2,0)&CHAR(10)&VLOOKUP(F6,$U$2:$Z$2000,3,0)
> >>
> >>Biff
> >>
> >>"Steved" <[email protected]> wrote in message
> >>news:[email protected]...
> >>
> >>>Hello from Steved
> >>>
> >>>Cell A1 =VLOOKUP(F6,$U$2:$Z$2000,2,0) will get the Surname ie "ADDISON"
> >>>Cell B1=VLOOKUP(F6,$U$2:$Z$2000,3,0) will get the first Names ie "Mark
> >>>James"
> >>>
> >>>Ok can I get the formula to combine the both to get = "ADDISON Mark James"
> >>>
> >>>so cell A1 ="ADDISON Mark James"
> >>>or
> >>>so cell A1 ="ADDISON
> >>> Mark James" (Wrap Check box ticked)
> >>>
> >>>Thankyou.
> >>>
> >>>
> >>>
> >>
> >>
> >>
>
> --
>
> [1] The SumProduct function should implicitly coerce the truth values to
> their Excel numeric equivalents.
> [2] The lookup functions should have an optional argument for the return
> value, defaulting to #N/A in its absence.
>

Hello from Steved

Cell A1 =VLOOKUP(F6,$U$2:$Z$2000,2,0) will get the Surname ie "ADDISON"
Cell B1=VLOOKUP(F6,$U$2:$Z$2000,3,0) will get the first Names ie "Mark James"

Ok can I get the formula to combine the both to get = "ADDISON Mark James"

so cell A1 ="ADDISON Mark James"
or
so cell A1 ="ADDISON
Mark James" (Wrap Check box ticked)

Thankyou.

Hi!

>so cell A1 ="ADDISON Mark James"

=VLOOKUP(F6,$U$2:$Z$2000,2,0)&" "&VLOOKUP(F6,$U$2:$Z$2000,3,0)

> so cell A1 ="ADDISON
> Mark James" (Wrap Check box ticked)

=VLOOKUP(F6,$U$2:$Z$2000,2,0)&CHAR(10)&VLOOKUP(F6,$U$2:$Z$2000,3,0)

Biff

"Steved" <[email protected]> wrote in message
news:[email protected]...
> Hello from Steved
>
> Cell A1 =VLOOKUP(F6,$U$2:$Z$2000,2,0) will get the Surname ie "ADDISON"
> Cell B1=VLOOKUP(F6,$U$2:$Z$2000,3,0) will get the first Names ie "Mark
> James"
>
> Ok can I get the formula to combine the both to get = "ADDISON Mark James"
>
> so cell A1 ="ADDISON Mark James"
> or
> so cell A1 ="ADDISON
> Mark James" (Wrap Check box ticked)
>
> Thankyou.
>
>
>

Hello Biff from Steved

Can I impose please and ask you to take it one more stage and that is #N/A
be blank.

Thanks.

"Biff" wrote:

> Hi!
>
> >so cell A1 ="ADDISON Mark James"
>
> =VLOOKUP(F6,$U$2:$Z$2000,2,0)&" "&VLOOKUP(F6,$U$2:$Z$2000,3,0)
>
> > so cell A1 ="ADDISON
> > Mark James" (Wrap Check box ticked)
>
> =VLOOKUP(F6,$U$2:$Z$2000,2,0)&CHAR(10)&VLOOKUP(F6,$U$2:$Z$2000,3,0)
>
> Biff
>
> "Steved" <[email protected]> wrote in message
> news:[email protected]...
> > Hello from Steved
> >
> > Cell A1 =VLOOKUP(F6,$U$2:$Z$2000,2,0) will get the Surname ie "ADDISON"
> > Cell B1=VLOOKUP(F6,$U$2:$Z$2000,3,0) will get the first Names ie "Mark
> > James"
> >
> > Ok can I get the formula to combine the both to get = "ADDISON Mark James"
> >
> > so cell A1 ="ADDISON Mark James"
> > or
> > so cell A1 ="ADDISON
> > Mark James" (Wrap Check box ticked)
> >
> > Thankyou.
> >
> >
> >
>
>
>

It's ok I looked up and found away

=IF(ISNA(VLOOKUP(F6,$U$2:$Z$2000,2,0)&CHAR(10)&VLOOKUP(F6,$U$2:$Z$2000,3,0)),"",VLOOKUP(F6,$U$2:$Z$2000,2,0)&CHAR(10)&VLOOKUP(F6,$U$2:$Z$2000,3,0))

Thankyou.

"Steved" wrote:

> Hello Biff from Steved
>
> Can I impose please and ask you to take it one more stage and that is #N/A
> be blank.
>
> Thanks.
>
> "Biff" wrote:
>
> > Hi!
> >
> > >so cell A1 ="ADDISON Mark James"
> >
> > =VLOOKUP(F6,$U$2:$Z$2000,2,0)&" "&VLOOKUP(F6,$U$2:$Z$2000,3,0)
> >
> > > so cell A1 ="ADDISON
> > > Mark James" (Wrap Check box ticked)
> >
> > =VLOOKUP(F6,$U$2:$Z$2000,2,0)&CHAR(10)&VLOOKUP(F6,$U$2:$Z$2000,3,0)
> >
> > Biff
> >
> > "Steved" <[email protected]> wrote in message
> > news:[email protected]...
> > > Hello from Steved
> > >
> > > Cell A1 =VLOOKUP(F6,$U$2:$Z$2000,2,0) will get the Surname ie "ADDISON"
> > > Cell B1=VLOOKUP(F6,$U$2:$Z$2000,3,0) will get the first Names ie "Mark
> > > James"
> > >
> > > Ok can I get the formula to combine the both to get = "ADDISON Mark James"
> > >
> > > so cell A1 ="ADDISON Mark James"
> > > or
> > > so cell A1 ="ADDISON
> > > Mark James" (Wrap Check box ticked)
> > >
> > > Thankyou.
> > >
> > >
> > >
> >
> >
> >

=IF(ISNUMBER(MATCH(F6,$U$2:$U$2000,0)),VLOOKUP(F6,$U$2:$Z$2000,2,0)&"
"&VLOOKUP(F6,$U$2:$Z$2000,3,0),"")

Steved wrote:
> Hello Biff from Steved
>
> Can I impose please and ask you to take it one more stage and that is #N/A
> be blank.
>
> Thanks.
>
> "Biff" wrote:
>
>
>>Hi!
>>
>>
>>>so cell A1 ="ADDISON Mark James"
>>
>>=VLOOKUP(F6,$U$2:$Z$2000,2,0)&" "&VLOOKUP(F6,$U$2:$Z$2000,3,0)
>>
>>
>>>so cell A1 ="ADDISON
>>> Mark James" (Wrap Check box ticked)
>>
>>=VLOOKUP(F6,$U$2:$Z$2000,2,0)&CHAR(10)&VLOOKUP(F6,$U$2:$Z$2000,3,0)
>>
>>Biff
>>
>>"Steved" <[email protected]> wrote in message
>>news:[email protected]...
>>
>>>Hello from Steved
>>>
>>>Cell A1 =VLOOKUP(F6,$U$2:$Z$2000,2,0) will get the Surname ie "ADDISON"
>>>Cell B1=VLOOKUP(F6,$U$2:$Z$2000,3,0) will get the first Names ie "Mark
>>>James"
>>>
>>>Ok can I get the formula to combine the both to get = "ADDISON Mark James"
>>>
>>>so cell A1 ="ADDISON Mark James"
>>>or
>>>so cell A1 ="ADDISON
>>> Mark James" (Wrap Check box ticked)
>>>
>>>Thankyou.
>>>
>>>
>>>
>>
>>
>>

--

[1] The SumProduct function should implicitly coerce the truth values to
their Excel numeric equivalents.
[2] The lookup functions should have an optional argument for the return
value, defaulting to #N/A in its absence.

Hello aladin from Steved

Yes much clearner Thankyou.

"Aladin Akyurek" wrote:

>
> =IF(ISNUMBER(MATCH(F6,$U$2:$U$2000,0)),VLOOKUP(F6,$U$2:$Z$2000,2,0)&"
> "&VLOOKUP(F6,$U$2:$Z$2000,3,0),"")
>
> Steved wrote:
> > Hello Biff from Steved
> >
> > Can I impose please and ask you to take it one more stage and that is #N/A
> > be blank.
> >
> > Thanks.
> >
> > "Biff" wrote:
> >
> >
> >>Hi!
> >>
> >>
> >>>so cell A1 ="ADDISON Mark James"
> >>
> >>=VLOOKUP(F6,$U$2:$Z$2000,2,0)&" "&VLOOKUP(F6,$U$2:$Z$2000,3,0)
> >>
> >>
> >>>so cell A1 ="ADDISON
> >>> Mark James" (Wrap Check box ticked)
> >>
> >>=VLOOKUP(F6,$U$2:$Z$2000,2,0)&CHAR(10)&VLOOKUP(F6,$U$2:$Z$2000,3,0)
> >>
> >>Biff
> >>
> >>"Steved" <[email protected]> wrote in message
> >>news:[email protected]...
> >>
> >>>Hello from Steved
> >>>
> >>>Cell A1 =VLOOKUP(F6,$U$2:$Z$2000,2,0) will get the Surname ie "ADDISON"
> >>>Cell B1=VLOOKUP(F6,$U$2:$Z$2000,3,0) will get the first Names ie "Mark
> >>>James"
> >>>
> >>>Ok can I get the formula to combine the both to get = "ADDISON Mark James"
> >>>
> >>>so cell A1 ="ADDISON Mark James"
> >>>or
> >>>so cell A1 ="ADDISON
> >>> Mark James" (Wrap Check box ticked)
> >>>
> >>>Thankyou.
> >>>
> >>>
> >>>
> >>
> >>
> >>
>
> --
>
> [1] The SumProduct function should implicitly coerce the truth values to
> their Excel numeric equivalents.
> [2] The lookup functions should have an optional argument for the return
> value, defaulting to #N/A in its absence.
>