Recent content by oomeheadhurts

Found the solution... pivot tables. DUH!!!

I have no preference. I just need a solution

by formatted I meant sorted

Hi! I was trying to achieve a lookup with built in functions but getting nowhere. Basically I have a table similar to the following AOL BUY 25.12 NOK BUY 33.67 CSC BUY 121.56 AOL SELL 27.39 CSC SELL 115.84 BAA BUY 65.52 NOK SELL 34.32 BAA SELL 65.52 The table is raw data and does not...

Hi Rofeu! That almost did the trick. the only problem was that FoundRange was assuming that the source table started from A1 which it doesn't So it was picking up the wrong option. I've modified it to work but still have some issues. The updated code is below. The issue is that the code works so...

Ah thats where I signed up! Computing services did a patch install overnight and on reboot lost my bookmarks. Well now, its not exactly a cross post - that's a different issue to this one. In any case thanks for posting the other link.

Hi Thanks for getting back. OK a little background on the formula. I have a Combo box with various option. Based on the combo box selection, a look-up on a table (from a different worksheet - "Options") is performed, and the appropriate information, including the hyperlink is extracted. What I...

Hello, I have very long and complicated formulas dveloping in my cells, and I was wondering if I can write a helper function to handle this. My stab at the function looks something like Function lookupMatch(name1 As Variant) As Variant Dim rng1 As Range rng1.Name = name1...