Thread: Look up tables
View Single Post
  #3   Report Post  
Joe Mac
 
Posts: n/a
Default 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