The following are the basics of using the VLookupAnyTwoColumns UDF


The VLookupAnyTwoColumns function performs a similar function to the built-in 'VLookup' (Vertical Lookup) function that is available within Excel. The VLookupAnyTwoColumns function searches for a matching string values within two columns and returns the cell value from another column. For example, the function can be used to look for a particular part and sub-part in a parts list and return the corresponding price.

The syntax of the function is:

=VLookupAnyTwoColumns(StringSearch1, StringSearch2, SearchColumn1, SearchColumn2, LookupColumn)


where

StringSearch1 can be a string ("string to be changed.") or cell reference (A1) representing the data to search for in the search column.

StringSearch1 can be a string ("string to be changed.") or cell reference (A1) representing the data to search for in the search column.

SearchColumn1 is the column in which to search for StringSearch.

SearchColumn2 is the column in which to search for StringSearch.

LookupColumn is the column that contains the return value.





Example:

I use this to return a part price by searching for a part in a column:

=="$" & VLookupAnyTwoColumns(M3,M4,H3,I3,J3)





  

Created with the Personal Edition of HelpNDoc: Free help authoring environment