![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(80, 5%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVS%3C/text%3E%3C/svg%3E)
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(41.6, 1%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETH%3C/text%3E%3C/svg%3E)
Hello @Veron Shuen,
Good day! Thank you for posting your valuable question on Microsoft Q&A forum.
Please understand that our forum is a public platform, and we will modify your question to cover your personal information including your organization domain name in the description.
Your personal data will be stored in our private messages and will automatically be deleted after 30 days.
Please notice to hide these personal or organization information next time you post error or some information to protect personal data.
I noticed the #N/A errors in your VLSFO and LSMGO columns. This usually happens when Excel can’t find an exact match in the lookup formula.
Microsoft’s official documentation explains that this usually happens for one of these reasons:
- The lookup value doesn’t exist in the source table
- There are extra spaces before or after text
- The lookup range or column reference is incorrect
- The formula is using the wrong type of match
- The data in the lookup table is spelled or formatted differently
To resolve this issue, you can follow these basic checks:
- Look for hidden spaces: Select the port or vessel name and review it in the formula bar to ensure there are no extra spaces before or after the text.
- Confirm the lookup value exists: Verify that the port or vessel name appears exactly the same in your price list, with identical spelling and formatting.
- Check your lookup range and return column: Ensure the formula is referencing the correct table range and pulling data from the intended column.
For your reference: NA function - Microsoft Support
If you’d like, feel free to share the formula you’re using in the VLSFO or LSMGO columns, I can help review it and adjust it so the #N/A errors are resolved.
Thank you for reaching out, and wishing you a wonderful day ahead!
If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.