VLOOKUP

Sorting with functions only

ANmar CHOOSE / Formulas - combined functions / LARGE / Lookup and References / MATCH / Math and Trig / ROW / SMALL / Standard functions / VLOOKUP September 5, 2022 August 25, 2022

This one is similar to http://xlfxs.com/sort-list-using-functions/ where we use some controls here that make it more user-friendly.

Searching table in 2 dimensions.

ANmar Formulas - combined functions / HLOOKUP / INDEX / Lookup and References / MATCH / Standard functions / VLOOKUP HLOOKUP / INDEX / MATCH / Search / VLOOKUP July 26, 2022 July 21, 2022

Using VLOOKUP + MATCH (HLOOKUP + MATCH, OFFSET + 2 MATCHes or INDEX + 2 MATCHes) to search a table in both axis. This post has been sitting for a …

Skills Grid

ANmar Conditional Formatting / Data Validation / Formulas - combined functions / IF / IFERROR / Logical / Lookup and References / Names / Non-functions / OFFSET / Standard functions / VLOOKUP / Worksheet October 26, 2018 December 5, 2018

A small Excel file to show how we can create a chart-like Excel sheet Used in my Resume to show different skill sets and the level of expertise in each

New function IFERROR, finally

ANmar IFERROR / VLOOKUP December 24, 2017 December 26, 2017

We have already gotten used to use VLOOKUP, MATCH and other functions that generates errors inside an IF But, we do not need that anymore We can use the new …

ANmar Lookup and References / Standard functions / VLOOKUP September 26, 2016 February 21, 2017

I have been asked for a while now to just put a simple VLookup function, here it is, I know this might be stupid to post it here, but we …