Nice!
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Krishnakumar" <[email protected]>
wrote in message
news:[email protected]...
>
> Hi Dan,
>
> May be...
>
> =LOOKUP(9.9999999999E+307,FIND(AA1,A2:A3000),Z2:Z3000)
>
> where AA1 houses the lookup value.
>
> HTH
>
>
> --
> Krishnakumar
>
>
> ------------------------------------------------------------------------
> Krishnakumar's Profile:
http://www.excelforum.com/member.php...o&userid=20138
> View this thread: http://www.excelforum.com/showthread...hreadid=396384
>
Bookmarks