Global 'Lookup' Ideas

[greg.hingsbergen]

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]

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