Get instant live Excel expert help with VLOOKUP functions
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
VLookup Reference is broken in a list based vlookup selection when duplicate values are chosen from the list for different cells
Solved by I. H. in 22 mins
Into the cell G1 I wish to use VLOOKUP to determine the examination score of the student named in cell F1. The range of cell A1:D77 is given the range name "results"
Fill in the blank part of the statement =VLOOKUP(
,
,
,TRUE)
Solved by F. A. in 30 mins
I need a formula to work with the large formula. I am finding the nth largest numbers and then using Vlookup to find a number in a cell next to this. I don't want it to just return duplicate numbers at the same nth degree if multiple same numbers
Solved by G. A. in 11 mins
i have one set of inventory reports in one sheet which have client name
IP address. i need to identify all the available client name for the given IPs.
tried VLOOKUP but i could find only one entry of the client name corresponding to the IP. But i need all the available client name corresponding to the IP.
Solved by F. E. in 15 mins
trying to get vlookup to fill in sheet when required for a purchase order book keeps returning #n/a
Solved by F. J. in 17 mins
I am trying to initiate a drop down menu with a list that's generated with partial match from VLookUp. The code is shown below:
Sub PipFitDes()
Dim j As Integer
LastRow = Sheets("Sheet1").Range("J" & Rows.Count).End(xlUp).Row
For j = 9 To LastRow
Sheets("Sheet2").Select
If Sheets("Sheet2").Cells(j, "E") <> "" Then
'Ename = Sheets("Sheet2").Cells(j, "E").Value
Sheets("Sheet2").Range("F9:F200").Select
With Selection.Validation
.Delete
.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _
xlBetween, Formula1:=Application.WorksheetFunction.VLookup("*" & Sheets("Sheet2").Cells(j, "E").Value & "*", Sheets("Sheet1").Range("H9:J2000"), 3, False)
.IgnoreBlank = True
.InCellDropdown = True
.InputTitle = ""
.ErrorTitle = ""
.InputMessage = ""
.ErrorMessage = ""
.ShowInput = True
.ShowError = True
End With
End If
Next j
End Sub
Solved by V. J. in 26 mins
Please, I would appreciate any assistance on how I can use the VLookUp function as the formula for creating the list in the data validation function.
Sub PipFitDes()
Dim j As Integer
LastRow = Sheets("Pipes & Fittings").Range("J" & Rows.Count).End(xlUp).Row
For j = 9 To LastRow
Sheets("Project Costing").Select
If Sheets("Project Costing").Cells(j, "E") <> "" Then
'Ename = Sheets("Project Costing").Cells(j, "E").Value
Sheets("Project Costing").Range("F9:F200").Select
With Selection.Validation
.Delete
.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _
xlBetween, Formula1:=Application.WorksheetFunction.VLookup("*" & Sheets("Project Costing").Cells(j, "E").Value & "*", Sheets("Pipes & Fittings").Range("H9:J2000"), 3, False)
.IgnoreBlank = True
.InCellDropdown = True
.InputTitle = ""
.ErrorTitle = ""
.InputMessage = ""
.ErrorMessage = ""
.ShowInput = True
.ShowError = True
End With
End If
Next j
End Sub
Solved by X. H. in 23 mins
I was trying to use VLookUp as the formula to extract matches in Column J of Pipes & Fittings, once a partial match excel of the size/dia specified in Column E of Project Costing Sheet.
Solved by K. F. in 20 mins
i am trying to make my formula return a zero if the lookup cells are blank =IF(SUM(O4:W4)="","","iferror(VLOOKUP(Y3,$D4:$K4,7,FALSE),""")
Solved by T. D. in 29 mins
I have a question about Excel. I need to create a formula similar to standard Vlookup, but instead of one look up value I need to have two of them and in different columns.
Solved by X. B. in 13 mins