Get instant live Excel expert help with VLOOKUP formula

I'm using vlookup to find a value. It populates in the cell where I create the formula, but when I attempt to drag it down I'm getting N/A. I've tried trimming and have checked the formula a million times to make sure it is correct.

I need to ask a question related to lookup function excel

I need help with a live vlookup formula to pull information from the import sheet and copy the relevant sheets e.g: SME, TI, KADs & LG

Hi there again, I tried fixing my formula using the Vlookup and nested with another vlookup formula (using a drop down box). I was able to get half of the formula to work, but when making a connection with the other part of the formula it is returning me a blank cell, when I actually have data in that cell.

The shipping fee charged is based on the amount of the parcel found in column B. Insert the VLOOKUP function in cell C4 to look up the shipping fee in the ShippingFees named range. The range has already been named for you. Note: The formula, including the range name, can be typed using lowercase letters. Do not enter anything for the range_lookup value.

hello, I am using a lookup function in tableau, but I want it to return the exact formula, not the text of the formula. Is this possible?

In this problem, you must first complete the Sales table below by entering equations in cells C22, E22, F22, and G22 that can be copied and pasted down for each sales transaction. This will require the use of the vlookup function to find the price and the discount. The net column should be calculated as Total * (1 - Discount)... Next you will need to fill in the totals for the green shaded cells at the bottom of the table. Once you have completed those tasks, the goal is to create a formula in cell D18 that will use the sumif formula to add up the net amount of sales to a particular customer... If the customer filter is blank (which can be tested in the if function by using B15 = "") then your formula should sum up the net amount of sales that satisfy the relationship specified by the Net Amount filter and the operator... For example, you may want to see what the sum is for transactions with a net amount in excess of $3,000. In that case you would type $3,000 in cell E15 and select the symbol > from the drop down box that I have already created for you in cell E16. If both filters are blank, then the cell D18 should just return the sum of the net column. To reiterate, your formula should first check to see if cell B15 is blank, if it is not, cell D18 should return the sum of all transactions for the customer ID listed in cell B15. If cell B15 is blank then your formula should check to see if cell E15 is blank, if it is not, your formula should sum up all transaction based on the amount listed cell E15 and the operator in cell E16. Finally if both Filters are blank, then the formula in cell D18 should just return the sum of the net column. To accomplish this task, you will need to use the IF function and the SUMIF function as well as one of the two methods of concatenation to fill in the cell D18.

I need to learn how to do vlookup in excel 2010 that calculates the charge of aspecific item

Hi I use a if error with VLOOKUP formula, cant get it work. I have 2 sheets would match the data. the formula =IFERROR(VLOOKUP('Sorting '!D2,'Sage Paste'!D2:D85,4,FALSE),"Not Found")

I am attempting to add conditional fomatting to column C, however, the cells with the VLOOKUP formula in them will not reflect the formation. C3-C6 do not have formulas and show the conditional formatting can you assist? The formatting should process from red to green from 20 to 70 being the all green,