The VLookupAnyColumn function performs a similar function to the built-in 'VLookup' (Vertical Lookup) function that is available within Excel.The VLookupAnyColumn function searches for a matching string value within a column and returns the cell value from another column. For example, the function can be used to look for a particular part in a parts list and return the corresponding price. The function can be used to find matching cells between ranges by setting the Lookup Column the same as the Search Column.
The syntax of the function is:
=VLookupAnyColumn(StringSearch, SearchColumn, LookupColumn, CaseSensitive)
=VLookupAnyColumn(StringSearch, SearchColumn, LookupColumn)
StringSearch can be a string ("string to be changed.") or cell reference (A1) representing the data to search for in the search column.
SearchColumn is the column in which to search for StringSearch.
LookupColumn is the column that contains the return value.
CaseSensitive is a boolean indicating that a case sensitive search is desired. Optional, default is false (case insensitive).
I use this to return a part price by searching for a part in a column:
="$" & VLookupAnyColumn(E2,A:A,B:B)
Created with the Personal Edition of HelpNDoc: Produce Kindle eBooks easily