Category: Lookup and References
Lookup and references functions, comes with Excel
![iframe in Excel (XLiFrame)](https://xlfxs.com/wp-content/uploads/2012/02/2012-02-19-0314441-e1329644096280-2.jpg)
iframe in Excel (XLiFrame)
ANmar February 19, 2012
![State Abbr with Index+Match+Validation](https://xlfxs.com/wp-content/uploads/2012/02/14-2-360x270.jpg)
State Abbr with Index+Match+Validation
ANmar February 14, 2012
![Zipcode-State search](https://xlfxs.com/wp-content/uploads/2012/02/S_0093_03-e1329040561245-2.jpg)
Zipcode-State search
ANmar February 12, 2012
![Extract Address into table](https://xlfxs.com/wp-content/uploads/2012/02/S_0086_01-2.jpg)
Extract Address into table
ANmar February 10, 2012
![Convert 2-column into wide (column-row) table](https://xlfxs.com/wp-content/uploads/2012/02/S_0107_021-e1328838196786-2-360x183.jpg)
Convert 2-column into wide (column-row) table
ANmar February 9, 2012
![Multiple Dual-Validations](https://xlfxs.com/wp-content/uploads/2012/02/S_0111_08-e1328782880388-2.jpg)
Multiple Dual-Validations
ANmar February 9, 2012
![WorksheetName and WorksheetsNo UDFs](https://xlfxs.com/wp-content/uploads/2012/02/S_0143_031-e1328655645317-2.jpg)
WorksheetName and WorksheetsNo UDFs
ANmar February 7, 2012
![Dynamic selection list](https://xlfxs.com/wp-content/uploads/2012/02/S_0080_02-e1328610436358-2.jpg)
Dynamic selection list
ANmar February 7, 2012
![Validation based on another Validation](https://xlfxs.com/wp-content/uploads/2012/02/1-2-360x270.jpg)
Validation based on another Validation
ANmar February 7, 2012
![Rotate table using 1 formula](https://xlfxs.com/wp-content/uploads/2012/02/S_0072_01-2-303x270.jpg)
Rotate table using 1 formula
ANmar February 6, 2012
![Sort list dynamically (functions)](https://xlfxs.com/wp-content/uploads/2012/02/2012-02-05-181039-e1328495673114-2.jpg)
Sort list dynamically (functions)
ANmar February 5, 2012