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(…)
DRM-Free Day, Mystery Spaces in Excel and Free Stuff Today! Read On!
On Sheet 1, you have Customer Data with Subtotals added by the Subtotal command. On Sheet 2, you have a list of
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
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