Syntax:
VLOOKUP(A2, D$11:E:22, 2, False)
Means:
If the value of cell A2 matches a value in the supplied range (Cells D11 to E22), the function's result is the value of the second column from the range, from the row containing the matching value.
This function and the matching HLookup function can be very handy.
Oren asked his readers for a way to create Word & Excel documents without using COM.
I read the answers, and came up with this list:
Excel:
Essential XlsIO for Windows Forms
Aspose Cells
Word:
Essential DocIO for Windows Forms
Aspose Words
TX Text Control
I ruled out all OpenXML solutions, because they really work only with Office 2007.
Users of Office 2003 may be able to use them, but only after installing a package, and users of older versions (as well as Open Office users) can't read those documents.
