+ Reply to Thread
Results 1 to 3 of 3

Need to look up values per X and Y axis.

  1. #1
    Registered User
    Join Date
    11-15-2012
    Location
    NYC
    MS-Off Ver
    Excel 2010
    Posts
    41

    Need to look up values per X and Y axis.

    Need to look up values per X and Y axis. I'm thinking an index formula would work, but I'm not sure.

    I've attached an example. Any help would be greatly appreciate!
    Attached Files Attached Files

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,679

    Re: Need to look up values per X and Y axis.

    Can't see your example, but it would help if you attached a sample Excel workbook.

    To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

    Don't try to use the Paperclip icon, as it doesn't work on this forum.

    Hope this helps.

    Pete

  3. #3
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Need to look up values per X and Y axis.

    Use
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] create x-axis and a y-axis chart as an image horizontal and vertical values
    By Khaldon in forum Excel Charting & Pivots
    Replies: 9
    Last Post: 10-11-2018, 09:12 AM
  2. Replies: 2
    Last Post: 12-16-2015, 06:25 AM
  3. Replies: 9
    Last Post: 09-22-2015, 02:43 AM
  4. Replies: 4
    Last Post: 07-31-2015, 12:54 AM
  5. Replies: 2
    Last Post: 03-17-2014, 07:58 AM
  6. Replies: 8
    Last Post: 02-12-2009, 10:12 AM
  7. [SOLVED] How to insert X axis scale values next to axis and X axis grid lin
    By vp23larry in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-23-2005, 11:05 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1