Get instant live Excel expert help with VLOOKUP formula
“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
Using the vlookup formula to gather information from multiple worksheets. there could be no value in with the related cell on some work sheets and value in the related cell on other worksheets, but with end product I still get error message. Any way I can work around it?
Solved by M. Q. in 13 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 need to create a vlookup or formula that copies data in a single column for a given association, to a single row with that same association. In other words, I want to take data that is listed vertically (in a single column) and copy it so that it shows horizontally (in a single row).
Solved by F. C. in 24 mins
Add a formula to cell G4 that creates a Report ID from the date and the ID number on the ListData worksheet of the person who made the report. The excel IF function TEXT will include a TEXT function and a nested IF function with a VLOOKUP function.
The logical test will verify if cell G2 is greater than 0.
The value if true will include the TEXT and VLOOKUP functions: TEXT(G2,"YYYYMMDD"),"")&" "&IF(G1>0,VLOOKUP(G1,ListData!B15:C19,2)
The value if false will return blank.
Solved by A. A. in 27 mins
I have data that's been exported to create a payroll spreadsheet. I want to get the job number's that were worked based on the date and employee ID number. It's not quite as easy as a VLookup because some employees work multiple jobs in one day. And I'm having trouble getting an Array formula to work.
Solved by F. F. in 16 mins
I'm applying a simple vlookup two columns, and when I copy and paste the formula down the column it returns the value of the first row. The formula appears correct in the formula bar for each row, but does not return that row's information.
Solved by X. D. in 11 mins
I am trying to write an IF formula that returns a vlookup result.
Solved by A. J. in 20 mins
Can these be answered with VLOOKUP or LOOKUP function google sheets and what is the formula?
Solved by T. J. in 11 mins
Vlookup formula not working when combining with IF. If formula alone is not sufficient.
Solved by V. Q. in 13 mins