Look up tables
 

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

Look up tables
 

Hi Mark, you're on the right page, just 2 lines above excel is the Access
Database forum

"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

Look up tables
 

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