Results 1 to 6 of 6

Formula that can look through multiple tables on same sheet

Threaded View

  1. 11-13-2013, 04:18 PM #1
    bouncingbudha
    bouncingbudha is offline
    Registered User
    Join Date
    09-03-2012
    Location
    Christchurch New Zealand
    MS-Off Ver
    Excel 2013
    Posts
    45

    Formula that can look through multiple tables on same sheet

    Hi I need a formula that can look through multiple tables and can pull out data when info is selected from drop down lists
    I have tried VLookup and Index but have not been able to crack it.
    File attached shows how many tables and what the drop down format looks like.
    Any help would be appriecated
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Dynamic table in a different sheet from multiple tables in other sheet
    By David Brown in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 03-27-2013, 12:22 AM
  2. [SOLVED] Convert Multiple Tables on a sheet to a List
    By smartk in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 07-22-2012, 11:29 AM
  3. Excel 2007 : Multiple Pivot Tables on one sheet
    By AltaS in forum Excel General
    Replies: 7
    Last Post: 03-27-2012, 07:20 PM
  4. change multiple pivot tables on 1 sheet
    By tinkerbelle in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-25-2008, 06:05 AM
  5. Filter multiple tables on the same sheet
    By John in forum Excel General
    Replies: 1
    Last Post: 06-15-2005, 04:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1