Get instant live Excel expert help with LOOKUP Function

I have a lookup formula that will not work on me Excel file (MAC)

I study in a course and just don't understand one of the solutions of a task (though I get the concept of the formulas). I have 3 sheets: 1) a raw data table with sales data: columns of Product ID, Price, Quantity, etc but I have to cleanse the data so I can use it properly for calculations, so I have to consolidate into 2) another sheet which contains the clean data, same columns and 3) i have a data lookup with a sum of Product IDs, Product descriptions, quantity, price, etc (this is the summary sheet of product types). Problem: in 1) raw data sheet, in the Product ID column in some cells there are Product IDs written, however in many cells the PRoduct descriptions are written, so it is messed up, and now I want to consolidate in sheet 2) using IFERROR & VLOOKUP from sheet 3) The solution is that I look for the value in sheet 1), from the range of sheet 3), and pick the Product ID column as I want to have the proper Product IDs in sheet 2). However, when I want to copy down, I need IFERROR, so when it is a product description it looks up that value. The official solution looks like this: =IFERROR(VLOOKUP(Data_Set_Raw!E8;Data_Lookup_Ans!$C$14:$J$25;1;FALSE);VLOOKUP(Data_Set_Raw!E8;Data_Lookup_Ans!$D$14:$J$25;7;FALSE)) - check Data_Set_Clean_Ans sheet F9 In the second vlookup, on sheet 3) the Product ID column was duplicated, and referenced as column 7, however the same values are in column 7 and 1 (that is in the first vlookup) My question is why do I have to duplicate the Product ID column and cannot use the VLOOKUP simply as both the Product descriptions and the Product IDs can be found in the same table?

On the Model worksheet, in cell B18, use the VLOOKUP and RAND functions to randomize the retrieval of a risk level from column F in the ClaimRisk named range. The RAND function will serve as the lookup value.

I need to be able to lookup and parse information based on certain criteria

Lookup a value from another workbook based on the name of the file.

i want to lookup a alphanumeric value(eg. EMP789 ) from a coloumn range i use =VLOOKUP(REPT("z",255),C:C,1) to get text value

Lookup formula from several taps in a workbook. To know know many Saturdays and sundays a person got from a long period of time

Need to lookup exact project id & project name from one sheet to anonther. the glitch is source sheet has one employee details for multiple times since the depend on project allocation dates

Can't figure out this formula in Excel. I want to lookup a certain number based on two different criteria.

I want to do a lookup to find multiple amounts in a horizontal row based on 1 identical horizontal reference and a single vertical reference. How can I do this? I am new to Indexing and Matching. Thanks