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?
Bookmarks