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