easy5 pts · first answer countsexcellookups
VLOOKUP returns wrong prices
You wrote =VLOOKUP(A2, Prices!A:B, 2) to find product prices. Some products get the price of a different product. What is the most likely cause?
Discussion 0
Join free to post in the discussion.
Related questions
- What a pivot table doesData Analyst
- Absolute references in ExcelData Analyst
- SUMIFS with two conditionsData Analyst
- Lost leading zeros in IDsData Analyst
- Looking up a value to the leftData Analyst
- Share of sales in a pivot tableData Analyst
- Pivot ignores new data rowsData Analyst
- Same cleaning every MondayData Analyst