Results 1 to 5 of 5

Function to retrieve values on second tab from tables on the first tab

Threaded View

  1. 03-01-2022, 12:16 PM #1
    viewotst
    viewotst is offline
    Forum Contributor
    Join Date
    04-03-2021
    Location
    Zaragoza
    MS-Off Ver
    2102 MICROSOFT 365
    Posts
    153

    Function to retrieve values on second tab from tables on the first tab

    Good afternoon,

    I hope you are well.

    I have a workbook with two different sheets: Stats and Function.

    On the stats sheet I have three different tables that I have been given names with the stats of three different teams.
    On the second sheet I want to get a formula that gives me in the cells D6, E6 and F6 the values of the references in DE5, E5 and F5 for both teams, local and away.


    Can you please help?


    Thanks
    Attached Files Attached Files
    Last edited by viewotst; 03-02-2022 at 07:57 AM.
    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. Compare two tables to retrieve data based on Column
    By elbrujo in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-30-2019, 06:03 PM
  2. [SOLVED] using IF function to retrieve output values from a table given an input value
    By medwar in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-24-2019, 12:24 PM
  3. Nesting IF & Lookup function to retrieve multiple values
    By agroeneveld in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-13-2017, 01:22 PM
  4. Lookup multiple values using a single word, retrieve values, sum, then divide by 20
    By Shaun Gemiver in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-22-2013, 07:42 AM
  5. Help with VLOOKUP function to retrieve values from another page
    By bagel in forum Excel General
    Replies: 8
    Last Post: 06-15-2011, 10:48 AM
  6. Returning multiple function values in tables
    By cookie365 in forum Excel General
    Replies: 0
    Last Post: 04-19-2011, 11:35 AM
  7. identifiying Dup values in column and retrieve oldest date in Dup values row
    By kwiz_ok in forum Excel General
    Replies: 14
    Last Post: 10-19-2010, 11:52 AM

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