Відео

Hi there! Thanks for trying out the formula! Sorry to hear you're facing an issue, let’s see if we can fix it together. Here are a few things to double-check: --Ensure the table is named properly: After converting the data to a table using Ctrl + T, did you rename the table to DataTable? You can check the table name by selecting any cell in your table, and in the top left corner of Excel (in the Name Box), it should say DataTable. --Check cell references: Make sure that your search box (where you're entering your search term) is linked to cell B2. You can verify this by right-clicking the text box, selecting Properties, and checking the Linked Cell field, which should be set to $B$2. --Formula Check: Here’s the formula again, ensure it’s copied exactly like this: =FILTER(DataTable, ISNUMBER(SEARCH($B$2, DataTable[Product Name])), "Not Found") DataTable should be the name of your table. Product Name should be the exact column header in your table (case-sensitive). --Error Message: If you're getting a specific error message, let me know what it says! We can troubleshoot it more from there. Let me know if this helps, and feel free to reach out if it’s still not working-happy to assist! 😊

Let me share with you a sample file and, download it to your PC for you to check and compare with your file. 1drv.ms/x/s!Amv47Z6vI-CfwQMiCvQ_ZNzJVsR3?e=fsQhD4

Thanks for your question! If the image isn't showing after downloading the file, here are a few things to check: Ensure Internet Connectivity: The IMAGE formula links to an online image URL, so make sure you are connected to the internet to display the images. Verify the URLs: Double-check that the URLs in the IMAGE formula are correct and still accessible online. Sometimes, images are removed or the links break, causing them not to appear. Excel Version: The IMAGE formula works in Excel 365 and Excel Online. Make sure you're using a compatible version of Excel. If you’re using an older version, the images may not show up. Try Re-Downloading: Sometimes, files may get corrupted during download. Try downloading the file again and see if that fixes the issue. Let me know if this helps or if you're still facing issues!"

Glad you liked it

Nice