Hello,
I am encountering issues with using the VLOOKUP function in my Google Sheets document (It´s in german). The problem involves retrieving values based on a dropdown selection and calculating values in different columns. Despite following various troubleshooting steps, the issue persists.
Here are the details of the problem:
1. **Spreadsheet Structure:**
- **Column B**: Dropdown menu for product selection (e.g., Blueberries, Raspberries).
- **Column C**: Daily harvest amount in kg.
- **Column D**: Kilogram price of the product.
- **Column E**: Total value of the harvest in Guaranis.
- **Column F**: Total harvest amount of the selected product in kg.
- **Column G**: Stock amount of the product in kg.
- **Column H**: Value of the product stock in Guaranis.
- **Columns J and K**: List of products and their prices (Price list).
2. **Problems Encountered:**
- The formula `=VLOOKUP(B2, J:K, 2, FALSE)` is not working, and it results in an error stating: "The value does not match the currency type."
- I have formatted columns D and K with custom currency settings but received errors indicating issues with the format.
- I attempted to resolve the issue by using alternative methods, including the INDEX and MATCH functions, but faced the same errors.
3. **Attempted Solutions:**
- Changed the format of columns D and K to "Number" and "Currency" instead of custom formats.
- Verified that the lookup values and return values are correctly formatted.
- Ensured there are no typographical errors or inconsistencies in the data.
I would appreciate any assistance or guidance on resolving this issue. Specifically, I need help with:
- Ensuring that VLOOKUP works with my data and currency formatting.
- Addressing the error messages related to currency type mismatches.
- Finding an alternative solution if VLOOKUP cannot be resolved.
For reference, here is a link to the spreadsheet with the issue: [Link to the spreadsheet]<URL removed by staff>
Thank you for your assistance!
LinkedIn
Twitter
