Wednesday, September 26, 2018
Home Tags Vlookup

Tag: vlookup

Convert a Letter to a Number

I am looking for a formula I can place in a column that will convert a letter to a number value. For instance, s=1, m=1.5, L=2.5. I want it to be a continous rule for the column, leaving find and replace not feasible. To solve this problem the built-in vLookup function can be used.


If you are planning to step up your proficiency in Excel, you should learn how to use the look up functions. These functions are commonly used on tables that act like a database. While databases have SQL queries, which is challenging especially for non-programmers, Excel has these simple look up functions and the most widely used are VLOOKUP, HLOOKUP and LOOKUP.

vLookup and Match Names and Numbers

For this problem we received some sample workbooks. We then used some formulas to compare the information and match the number to the name

Search for earliest date in Excel list using vLookup

The solution to this problem can be approached in a number of ways. In this post we will describe and method that uses VLOOKUP a built-in Excel function to derive the result.