Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
overlapping pivot tables | Excel Discussion (Misc queries) | |||
How to pull numbers from two tables with conditions? | Excel Worksheet Functions | |||
Macro for Pivot Tables | Excel Discussion (Misc queries) | |||
Autofiltering multiple tables on a spreadsheet | Excel Worksheet Functions | |||
How to paste Xcel tables legibly into Word . Help!! | Excel Discussion (Misc queries) |