Access 2010 – Paste and Delete options disabled

I found that with a pre-Access 2010 database opened in Access 2010, you can’t copy and paste a table. I use this function to backup a ‘reservations’ table before clearing it out to start a new round of reservations. The common accepted solution is to create a new database, but at this point I […]

MS Excel – Do Not Show #N/A

If you don’t want to see that nasty #N/A when doing lookups in Microsoft Excel, you can use the ISNA function in an if statement. (From http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=446 )

So, our criteria is IF the VLOOKUP returns #N/A, give me an empty cell, but if it doesn’t, give me the result of the VLOOKUP.

Let’s […]