Skip to main content

VLOOKUP

The VLOOKUP function in Excel is used to search for a specific value in a table and return a corresponding value from a specified column. The function has the following syntax: VLOOKUP(value, table, column, [approximate_match]) The first argument, "value", is the value you want to search for in the first column of the table. The second argument, "table", is the range of cells that make up the table. The third argument, "column", is the column number of the table that contains the value you want to return. The fourth argument is an optional argument, [approximate_match], which is a logical value that specifies whether you want an exact or approximate match. If it is set to TRUE or omitted, an approximate match is returned. If set to FALSE, an exact match is returned. Example: =VLOOKUP(A2,B2:D5,3,FALSE) In this example, the function will look for the value in A2 in the first column of the table B2:D5, and return the corresponding value from the third column of the table.
Labels:

Comments

Post a Comment

Popular posts from this blog

Get multiple lookup values in single cell

Post a Comment
Read more

Rupees into words

Option Explicit Function RupeesInWords(ByVal MyNumber As Double) As String Dim Rupees As String Dim Paise As String Dim Temp As String Dim DecimalPlace As Integer MyNumber = Round(MyNumber, 2) DecimalPlace = InStr(MyNumber, ".") If DecimalPlace > 0 Then Rupees = Left(MyNumber, DecimalPlace - 1) Paise = Mid(MyNumber, DecimalPlace + 1) Else Rupees = MyNumber Paise = "" End If RupeesInWords = "" If Val(Rupees) > 0 Then RupeesInWords = ConvertToWords(Rupees) & " Rupees" End If If Val(Paise) > 0 Then RupeesInWords = RupeesInWords & " and " & ConvertTwoDigits(Left(Paise & "00", 2)) & " Paise" End If RupeesInWords = Application.WorksheetFunction.Trim(RupeesInWords) & " Only" End Function Private Function ConvertToWords(ByVa...
Post a Comment
Read more