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
I have a drop down menu of 3 options, cover only, fibre and feather. If fibre I would like to use a VLOOKUP formula, or if feather I would like to use a different VLOOKUP formula or if cover only value would be 0. VLOOKUP formula needs to relate to a size and each one would relate to a different costing table.
Solved by K. A. in 30 mins
Switch to the worksheet “Internet user and pop. Table”. Use a VLOOKUP function in cell F2 so that it searches for the country in A2 (of current worksheet) that also appears within the “2016” worksheet and display its number of internet users. Expand the formula down to find the number of internet users for each country.
Solved by V. H. in 11 mins
I am using this formula =IF(C4="","",VLOOKUP(C4,Labels!B:M,3,)) and the cell where the value is is merged and won't give me the correct value.
Solved by E. A. in 12 mins
I'm trying to add the following formula to the Paid Amount column on the Bill tab - VLOOKUP([unique id in this row],[’Revenue Report’!all data],[sum paid column number],FALSE).
Solved by B. C. in 18 mins
Excel question = If data in sheet 1, column A matches data in sheet 2, column A, then I need it to pull data from sheet 2 column B and place it into sheet 1 column c. what is the vlookup column formula for this?
Solved by B. J. in 17 mins
Hi ,
I have got error value is not available for function or formula.
I have used vlookup function and looking value is taken from another cell which is calculated from another vlookup function.
I am 100% sure that looking value exist in the spreadsheet.
\Thanks.
Solved by T. B. in 21 mins
I am using a vlookup to generate a result in a column but I then want to adjust the result using a dropdown list, but don't want to damage the original formula
Solved by Z. L. in 11 mins
i need to combined both my sumif formula and vlookup formula that i have in the file but separate
Solved by D. S. in 13 mins
What happens when a vlookup value isn't there? I have two ranges, each two columns wide - a description and a count. I am trying to add them together. In the sample below, the RESULTS table is perfect for Items 1-3, but gives #N/A for Item 4. My formula in the Results table is simply a VLOOKUP into TABLE1 plus the VLOOKUP into TABLE2.
TABLE1
Item 1 3
Item 2 4
Item 3 8
< no Item 4 here
and
TABLE2
Item 1 7
Item 2 2
Item 3 1
Item 4 7
RESULTS
Item 1 10
Item 2 6
Item 3 9
Item 4 #N/A < error caused by no Item 4 in one table
Solved by K. D. in 19 mins
i need help creating a vlookup formula to look up and return the department head names for each department.
Solved by T. H. in 11 mins