Get instant live Excel expert help with VLOOKUP formula

i have a vlookup that is supose to populate a field from another sheet and it is not working...but i not seeing where I made the mistake on the formula

New Perspectives Microsoft Office 365 and Excel 2016 : Comprehensive, Loose-Leaf Version Module 8 Working with Advanced Functions page 528 question #5: In cell B18, create a formula using nested IF functions and VLOOKUP functions to determine what to do with the returns. Use the lookup table in the Return Data worksheet. Refer to Figure 8-46 for some hints on how to create the formula.

question #5: In cell B18, create a formula using nested IF functions and VLOOKUP functions to determine what to do with the returns. Use the lookup table in the Return Data worksheet. Refer to Figure 8-46 for some hints on how to create the formula.

Need help calculating commission based on the excel file I am attaching. The determination of the appropriate commission requires more complicated logic than the base pay. It is recommended that you add a column for “Commission Sales” where you create a formula using the VLOOKUP function to determine how much sales the associate requires for commission (# of hours multiplied by Hourly Sales in the lookup table – this will give you the amount of sales that is required to earn commission). Once you have calculated this, the commission formula must determine if a commission is to be paid, the applicable commission rate, the portion of sales on which to base the commission. Since the commission formula involves several lookups and decisions, you realize that nesting the IF and VLOOKUP functions is required.

the commission formula must determine if a commission is to be paid, the applicable commission rate, the portion of sales on which to base the commission. Since the commission formula involves several lookups and decisions, you realize that nesting the IF and VLOOKUP functions is required. The commisson figures are located on the Data sheet and the total hours worked for each employee is on the last sheet.

DESCRIPTION: =IF(ROWS(A$7:A7)<=$E$3,INDEX('ENTER DATA - PRODUCTION'!A$2:A$16732,SMALL(IF('ENTER DATA - PRODUCTION'!$B$2:$B$16732='DO NOT TOUCH - ARRAY FUNCTION'!$B$1,IF('ENTER DATA - PRODUCTION'!$J$2:$J$16732="B2",ROW('ENTER DATA - PRODUCTION'!$J$2:$J$16732)-ROW('ENTER DATA - PRODUCTION'!$J$1)+1)),ROWS(A$7:A7))),"") What is wrong with this formula. I'm using this for duplicate Vlookup function. I get #NUM! error.

I have the following code: If (cell.Value) - Range("C2") > cell.Offset(0, 2) Then. I want to change Range("C2") to be a vlookup. I tried changing the code to If (cell.Value) - Formula = "=VLOOKUP(M4,Sheet2!A:B,2,0)" > cell.Offset(0, 2) Then. but this didn't work.

I need help with a formula that can VLOOKUP then add 2 possible values that are in the same row. So sheet 1 is where I want to place the values. Sheet 2 contains dollar amounts I want to add, then bring to sheet 1.

I am formatting a column of number/letters to be stored as text. A formula relies on a vlookup with this column being used as the first criteria. It should work fine however I must go into each cell in the column, hit F2, then hit enter for the formula to identify it is stored as text. Is there an easier way to do this for the entire column since it is thousands of cells?

Please take a look at the formulas in first tab Cell C13 or C14. First the nested IF statement with following VLOOKUPS is returning a NAME? error. Second, in Cell C14 it is returning the wrong price value from the VLOOKUP array. The formula is the same one just shortened. What I need to do is have A13 pick list item selected, then have the selection in H13 made, and it populate the correct price.