# 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!”

## Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

## 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