Global 'Lookup' Ideas

[greg.hingsbergen@gmail.com]

One of my clients has an ever changing list of events that they are
working with. I need to pull information about those events into
various different workbooks.

I am planning on building a custom function that pulls the needed
information from a master spreadsheet [i.e.
=EventInfo("EventCode",EventDate) would give me the planned date of the
selected event].

Does anyone have any better ideas for formulaically retrieving specific
field data into Excel from a remote master database?

Also, it needs to be something I can do via Office Professional in a
small office environment (i.e. not SharePoint or any other enterprise
type solutions).

[Franz Verga]

greg.hingsbergen@gmail.com wrote:
> One of my clients has an ever changing list of events that they are
> working with. I need to pull information about those events into
> various different workbooks.
>
> I am planning on building a custom function that pulls the needed
> information from a master spreadsheet [i.e.
> =EventInfo("EventCode",EventDate) would give me the planned date of
> the selected event].
>
> Does anyone have any better ideas for formulaically retrieving
> specific field data into Excel from a remote master database?
>
> Also, it needs to be something I can do via Office Professional in a
> small office environment (i.e. not SharePoint or any other enterprise
> type solutions).


You can build a "supercode" column in your master sheet, by joining the
EventCode and Event Date columns, i.e. if colum A is the supercode column,
Column B is the EventCode and column C is the Event Date column, you can
type in A2 (I suppose you have headers in row 1): =B2&C2 and copy across the
rows.

Then you can use a VLOOKUP function to have informations from the master
sheet.


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy