Prevent #N/A! in Excel VLOOKUP


So, you have this nice little =VLOOKUP(A2,$Z$2:$AB$99,3,False) formula. But in order to prevent the #N/A! error when something is not found, you used to have to do the VLOOKUP twice:  =IF(ISNA(VLOOKUP(A2,$Z$2:$AB$99,3,False)),”Not Found”,VLOOKUP(A2,$Z$2:$AB$99,3,False)). This is far simpler starting in Excel 2010: Think about it. Let’s assume you are doing 1000 VLOOKUPs. There are 990 that are(…)

Learn Excel – “Mysterious Leading Space”: Podcast #1884


DRM-Free Day, Mystery Spaces in Excel and Free Stuff Today! Read On!

Learn Excel – “VLOOKUP into Subtotaled Data”: Podcast #1882


On Sheet 1, you have Customer Data with Subtotals added by the Subtotal command. On Sheet 2, you have a list of

Learn Excel – “Self-Maintaing Lookup Table”: Podcast #1868


Enter a product on Sheet 1. You want a VLOOKUP Formula to grab the description from a Lookup Table on Sheet 2. However, if the product is missing from Back

Learn Excel – “VLOOKUP to 3 Sheets”: Podcast #1861


Latasha asks how to use ‘VLOOKUP’ into three Worksheets. Her product number might be found on the master product list, but it might be Back

Learn Excel from MrExcel