Hi - I am very familiar with VLOOKUPs... howeer I think what I need here is an HLOOKUP but failing so maybe you can help.
Here is what I am trying to do.
I have a pivot table that has a group title and counts, then under each main grou ptitle is a lits 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