A "Simple" Speadsheet to generate random products to import into Magento

I created an Excel spreadsheet that auto-generates 10,000 product SKU's from a list of words. I kept getting "#VALUE!" errors using the LOOKUP function in Excel.

The answer was to press CTRL-SHIFT-ENTER when entering the formula! Weird...

By using an "Array Formula" the errors went away! Very pesky bug to chase down, figured I'd post it here.

The weirdest thing, I only got the error after 1,000 rows... And such.


Subscribe to RSS - Import