In other words, each column should contain the same type ... Luckily, you can do this in just a few steps using Excel's transpose pasting function. Many online forums and tutorials state that ...

DGET doesn't work with horizontal tables (where the categories are in rows, and the data are in columns). Use Excel's transpose tool to flip the database's structure, use HLOOKUP, which is ...