Hey Mark...
There are a number of built in Excel function that allow for table lookup...
it all depends on how you want to gain access to the data... review the
Online Help for VLookup, HLookup, Lookup, Index, functions for starters...
they are all useful in returning data or references to data locations in
other Excel tables or spreadsheets...
Personally I use VLookup as a favorite Lookup tool
--
Thanks for your help -
Joe Mac
"mark_b2410" wrote:
Hi all
Sorry to interrupt your Excel forum, but does anyone know of a similar
forum or website that deals with Microsoft Access?
Also, how do you create Lookup tables in Excel? I've had a quick look
in the tips section but couldn't find anything
Thanks
Mark
--
mark_b2410
------------------------------------------------------------------------
mark_b2410's Profile: http://www.excelforum.com/member.php...o&userid=16848
View this thread: http://www.excelforum.com/showthread...hreadid=478180