Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: oomeheadhurts
- Content: Threads
- Order by date
-
Diffing two values
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...- oomeheadhurts
- Thread
- Replies: 4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Help with formulas in functions
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...- oomeheadhurts
- Thread
- Replies: 8
- Forum: VBA Visual Basic for Applications (Microsoft)
