Office 2010 Professional Plus Daniel’s Extreme Lo

Today’s author is Daniel Wiesenfeld, an Excel and Access Power User who is sharing his Extreme Lookup Collection with us so we can use the Excel User Defined Functions (UDFs) he created to enhance the lookup functionality. His web site danalytics.biz is currently under construction and should be available soon.In the Visual Basic Editor, insert a Module and paste the following code:' XVLOOKUP (& XHLOOKUP)' Works just like a vlookup (and hlookup) except that the user refers to a lookup colum (or row)
' rather than a range, it is 0 based and the user can "look left" (or "look upward") by using a negative
' column (or row) index.' There is also an optional argument to allow the user to offset the cell to be returned by any number
' of rows (or columns)' I do not give users the option to choose between exact or approximate match - it is always exact Function XVLOOKUP(Lookup_Column As Range, Lookup_Value As Variant, Column_Index As Integer, _ Optional Row_Offset As Integer) Dim DCol, DRow As IntegerDim DSheet, strCRange, strARange As StringDim ARange As Range DCol = Lookup_Column.ColumnDCol = DCol + Column_Index If IsMissing(Row_Offset) Then Row_Offset = 0End If DSheet = Lookup_Column.Parent.NamestrCRange = Lookup_Column.Address DRow = WorksheetFunction.Match(Lookup_Value, Worksheets(DSheet).Range(strCRange), 0)DRow = DRow + (Lookup_Column.Row - 1) + Row_Offset Set ARange = Range(Cells(DRow, DCol), Cells(DRow, DCol))strARange = ARange.Address XVLOOKUP = Worksheets(DSheet).Range(strARange).Value End Function Public Function XHLOOKUP(Lookup_Row As Range, Lookup_Value As Variant, Row_Index As Integer, _ Optional Column_Offset As Integer) Dim DCol, DRow As IntegerDim DSheet, strRRange, strARange As StringDim ARange As Range DRow = Lookup_Row.RowDRow = DRow + Row_Index If IsMissing(Column_Offset) Then Column_Offset = 0End If DSheet = Lookup_Row.Parent.NamestrRRange = Lookup_Row.Address DCol = WorksheetFunction.Match(Lookup_Value, Worksheets(DSheet).Range(strRRange), 0)DCol = DCol + (Lookup_Row.Column - 1) + Column_Offset Set ARange = Range(Cells(DRow, DCol), Cells(DRow, DCol))strARange = ARange.Address XHLOOKUP = Worksheets(DSheet).Range(strARange).Value End Function 'XVHLOOKUP'looks up value in a range based on column and row headersPublic Function XVHLOOKUP(Lookup_Range As Range, Row_Header As Variant, Column_Header As Variant) Dim DCol, DRow, TRow, BRow, LCol,Office 2010 Activation, RCol As IntegerDim DSheet, strCRange, strRRange,Office Professional Plus 2010, strARange As StringDim CRange, RRange, ARange As RangeDSheet = Lookup_Range.Parent.Name TRow = Lookup_Range.RowBRow = TRow + Lookup_Range.Rows.Count - 1 LCol = Lookup_Range.ColumnRCol = LCol + Lookup_Range.Columns.Count - 1 Set CRange = Range(Cells(TRow, LCol), Cells(BRow, LCol))strCRange = CRange.Address DRow = WorksheetFunction.Match(Row_Header, Worksheets(DSheet).Range(strCRange), 0)DRow = DRow + Lookup_Range.Row - 1 Set RRange = Range(Cells(TRow,Windows 7 Ultimate, LCol), Cells(TRow, RCol))strRRange = RRange.Address DCol = WorksheetFunction.Match(Column_Header, Worksheets(DSheet).Range(strRRange), 0)DCol = DCol + Lookup_Range.Column - 1 Set ARange = Range(Cells(DRow, DCol), Cells(DRow,Windows 7 64 Bit, DCol))strARange = ARange.Address XVHLOOKUP = Worksheets(DSheet).Range(strARange).Value End Function 'XLOOKUP'Looks up value in a range and returns value of cell that is a specified number of rows and columns
'away from lookup cells Public Function XLOOKUP(Lookup_Range As Range, Lookup_Value As Variant, _ Row_Offset As Integer, Column_Offset As Integer) Dim DRow, DCol As IntegerDim DSheet, DAddress, strARange As StringDim ARange As Range DRow = Lookup_Range.Find(Lookup_Value).RowDCol = Lookup_Range.Find(Lookup_Value).Column DRow = DRow + Row_OffsetDCol = DCol + Column_Offset DSheet = Lookup_Range.Parent.Name Set ARange = Range(Cells(DRow,Office 2010 Professional Plus, DCol), Cells(DRow, DCol))strARange = ARange.Address XLOOKUP = Worksheets(DSheet).Range(strARange) End Function <div

Sports Network (AFP) reporter Wei Peng, a sixtieth old man, his wife on the frail and sick of this,tory burch shoes, yet the two are not related to the oldest old and their care for the elderly in every possible way. One of the old passed away though, but she has no regrets, because she had to experience the world of true love. The name of the truth the old man called Gluten Chi, who lives in the former Automotive Industry Corporation family member courtyard of Daqing Road.
villagers when their loved ones, from time to time to care

yesterday afternoon, the reporter saw 66-year-old Xiangyang People's Hospital of Gluten blog, he is to take care of seriously ill wife. Because his wife had a stroke, Gluten blog is not get away. He has been taken care of by the 85 year-old man was his brother Zhou Renhua Zhongxiang received temporary accommodation.
Gluten-chih,tory burch pumps, said Zhou Renhua home in Henan, is a fellow with his mother, two people often meet early. His school,tory burch flip flops, often to Zhou Renhua house to play.
Zhou Renhua young body is not very good, Gluten Chi visited him in his home to help with the housework. Zhou Renhua has not been husband and wife have children, adopted a son and a daughter, but after two children grow up and marry to the field and rarely home.
elderly people are not happy, someone to look after

2002,tory burch outlet, the Zhou Renhua lived in Shop Street to the demolition gun, get the compensation. Henan relatives heard the news come to Xiangfan, put them picked up. house to stay.
At that time, Zhou Renhua wife Zhang Guiyun health is getting worse, every few days to the hospital. ZHAO Chang-Zhi Zhang Guiyun often go to the hospital carrying, and sometimes lived in the second home in fear of a accident. Later invited the nanny, a day to two old cook.
care and nail in the coffin, two do not easily

2004 One day in late at night, Zhang Guiyun to the Gluten Chi called to say walk away nanny quit. Early next morning, Gluten put two old blog received its own house stay downstairs.
this way, Gluten blog every day to run upstairs two downstairs. However, ZHAO Chang Zhi of the ailing wife to have a stroke patient. At home to take care of his wife, but one old couple received a phone call and went downstairs to take care of two elderly people.
even worse, Zhang Guiyun has been completely unable to the. ZHAO Chang-Chi will be carrying a woman on the toilet,tory burch sales, to help the old couple taking a bath, cook for them. When it is too busy to let her daughter to take care of his wife, his second home altogether to live in, sleep next to them, . A few days ago, Gluten help Zhouren Hua Chi Zhang Guiyun's funeral brought back,tory burch flip-flops, then he has to busy looking for a cemetery.