Most would prepopulate the cell with (assume the value is entered in A1 -
then in B1)

=if(A1="","",vlookup(A1,Sheet3!A:M,3))

If you mean a database like Access or SQL Server rather than a "table" on a
worksheet, then you could retrieve the data by using the Change event as a
trigger.

http://www.cpearson.com/excel/events.htm for an overview of what events are
available.

--
Regards,
Tom Ogilvy


"jwilliamson" wrote:

>
> I have never done any programming in excel, I am a pretty experience
> programmer but here is my dillema. I need a spreadsheet, that when you
> type a value in a cell, it looks up the value in a database (it is the
> primary key of the table) and populates other columns in that row with
> the data associated with that value. Is this something feasable to
> program in excel? If it is, how would I go about getting this to work.
> Thanks.
>
> -Jon Williamson
>
>
> --
> jwilliamson
> ------------------------------------------------------------------------
> jwilliamson's Profile: http://www.excelforum.com/member.php...o&userid=34493
> View this thread: http://www.excelforum.com/showthread...hreadid=542593
>
>