# Get instant live Excel expert help and learn how to use an IF function with a VLOOKUP

“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

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 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 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 need to find the mismatch category, so I want to check if "Comments of cell in table" exist in Comments cell of report, if yes then need the value of mismatch category in report from table using vlookup.
Solved by M. U. in 22 mins
can i use the below expression If(and(vlookup(
Solved by B. D. in 16 mins
Hi, I am trying to compare 2 sheets in excel. I wanted to use Vlookup but not sure how to set it up correctly. So if an item on sheet 2, exists on sheet 1 (the master file), I want it to return a value in column 4 on sheet 1. Can someone please help?
Solved by B. B. in 21 mins
Need help with IF, MATCH, and excel LOOKUP function. Need to crosscheck 2 columns and once a match is found, return a value from the neighboring column.
Solved by Z. H. in 19 mins
i would like to apply vlookup. if there is 1 pc in transit and 2 pc in pending then result should be ETA date in 1 pending line and "No ETA" in second pending lines.
Solved by G. D. in 14 mins
I would like to have a cell look up a value on another sheet in a workbook and if the number is there and is greater than 0, then have the cell say "Yes." If the value is not there/is blank, then have the cell say "Budgeted Cost." Please find the formula I am currently using, below" =IF((VLOOKUP(B39,Tracker!\$A\$3:\$N\$200,14,FALSE)>0),"Yes","Budgeted Cost")
Solved by E. H. in 19 mins