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!”
Here are some problems that our users have asked and received explanations on
I am trying to create a vlookup to return a value from another source
Solved by S. J. in 11 mins
Need helping fixing a Vlookup formula with user input data
Solved by E. Q. in 16 mins
I've just had my software upgraded to Office 365 from Office 2016 and the formula in one of my spreadsheets isn't working. I've copied the formula below. It copies data from one sheet to another in the workbook, based on a particular value.
=IF(ISNA(VLOOKUP(K45;'Work Sheet '!$G$12:$H$100;2;FALSE));" ";(VLOOKUP(K45;'Work Sheet '!$G$12:$H$100;2;FALSE)))
Solved by S. S. in 12 mins
I have a VLOOKUP function that returns a value from another sheet that has a list of new prices. When the value changes (IE- When we insert updated prices, the VLOOKUP will still return the new value.) However, because of the extensive list of prices, we want to be able to have the changed values highlighted. Is there a way to do this?
Solved by E. J. in 20 mins
I have two sheets in a workbook. The first sheet has formulas to determine a set price. The second sheet has a column that uses vlookup to display the price from the formula. I have another column on that same sheet with old prices. I want to use conditional formatting to highlight prices that are different, but it seems to highlight everything based off of the formula, even if the prices are the same. How can I get it to compare the values from the formula?
Solved by A. B. in 21 mins
Hello, I'm trying to use vlookup in reverse, and excel "does not understand" the formula.
Solved by A. A. in 15 mins
Can you create a vlookup for fields containing the name rather than an exact match
Solved by K. J. in 28 mins
Hi, I have 1 spreadsheet with two tabs. On my first sheet I have on hand inventory consisting of an item description and on hand count taken from a few days ago. On my 2nd sheet I have the same item description and a count that was sold. I am trying to create a vlookup on my 1st page to look at the item description and if that appears in Column H:H then to take the number corresponding to the sold item and place it on the first page in a new column next to the old item count. Hope this makes sense...
Solved by O. B. in 11 mins
I doing a vlookup from current data to bring in data from another excel spreadsheet but its showing me a #value!
what am i doing wrong? =VLOOKUP($C$2:$D$1156,'[LM09 Timesheets WE 28 10 2018.xlsx]Data'!$C$4:$E$615,3,FALSE)
Solved by D. C. in 28 mins
I am having trouble with a vlookup function. should be simple but I am stuck
Solved by T. D. in 16 mins