Category: Lookup and References

Lookup and references functions, comes with Excel

iframe in Excel (XLiFrame)

ANmar February 19, 2012

State Abbr with Index+Match+Validation

ANmar February 14, 2012

Zipcode-State search

ANmar February 12, 2012

Extract Address into table

ANmar February 10, 2012

Convert 2-column into wide (column-row) table

ANmar February 9, 2012

Multiple Dual-Validations

ANmar February 9, 2012

WorksheetName and WorksheetsNo UDFs

ANmar February 7, 2012

Dynamic selection list

ANmar February 7, 2012

Validation based on another Validation

ANmar February 7, 2012

Rotate table using 1 formula

ANmar February 6, 2012

Sort list dynamically (functions)

ANmar February 5, 2012