+ Reply to Thread
Results 1 to 5 of 5

Need a formula to call out a column line item in another tab

  1. #1
    Registered User
    Join Date
    12-17-2009
    Location
    US
    MS-Off Ver
    Excel 2003
    Posts
    5

    Need a formula to call out a column line item in another tab

    Hi - I am very familiar with VLOOKUPs... however I think what I need here is an HLOOKUP but failing so maybe you can help. I think I am using the wrong formula or not doing it right.

    Here is what I am trying to do.

    I have a pivot table that has a group title and counts, then under each main group title is a list of all the URL's that bubble up to those numbers. I want to create a sheet where the First URL is showing NEXT to the Main Group title, not under the pivot.

    So basically I created a tab and tried an HLOOKUP - thinking if I find the title, then one row down it will populate in, versus doing a VLOOKUP that I would call the right/column number.

    What am I doing wrong?

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,910

    Re: Need a formula to call out a column line item in another tab

    It would help a lot if you can attach a sample workbook without sensitive data. From the description, it sounds like MATCH / INDEX might solve your problem, but I can't tell without seeing how the data are organized.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

  3. #3
    Registered User
    Join Date
    12-17-2009
    Location
    US
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Need a formula to call out a column line item in another tab

    Great thanks - yeah see attached - numbers all changed so not sensitive or real data but the pivots are real.

    Pivot table on tab 1. Tab 2 is waht I am trying to fill in. I am trying to call the URL from the pivot for the name of the Recipe that is in the first line of the group under that recipe on the pivot.

    So for example "Spinach Dip" had about 20 different URL's - but the first line under the Spinach Dip on the pivot is this /en-US/recipes/detail/9278/1/knorr-spinach-dip so that is what I would want to put in my URL column.

    Thanks -
    Attached Files Attached Files

  4. #4
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Need a formula to call out a column line item in another tab

    This returns many more values than you currently have but there are values that are not enough the same and errors are returned.
    Enter in row 3 where you want the results and fill down.
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  5. #5
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,910

    Re: Need a formula to call out a column line item in another tab

    Do you mean like the attached? The way to get this is to right click on the main title, select Field Settings. In Subtotals and Filters click on None. In Layout & Print, select Show item labels in tabular form. I think this will work in Excel 2003.
    Attached Files Attached Files
    Last edited by dflak; 05-16-2016 at 09:09 AM. Reason: Add attachment

+ 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. Replies: 9
    Last Post: 12-28-2015, 01:38 PM
  2. [SOLVED] Formula needed - line item of unique item matching criteria
    By NS4Excel in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 04-18-2015, 06:32 PM
  3. UserForm: Search Item in List > Call Table associated with Item > Execute Command
    By TexasAggie12 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-25-2014, 12:58 PM
  4. Pick item in column to be shown in line and columns
    By kuzna26 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-21-2014, 05:30 AM
  5. selected item from column to line
    By kuzna26 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 01-17-2014, 06:31 AM
  6. select/ Unselect of item from column to line without shifting
    By kuzna26 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-09-2014, 09:16 AM
  7. Combining multiple line items into one line item based on column.
    By mguz018 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-20-2012, 07:22 PM

Tags for this Thread

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