I’ve figured out parts of how to do this, but I can’t seem to get it to work. Basically, I want to check if a range of cells in a different sheet contians only null cells. The difficult part is that I need to be able to pull both the name of the sheet that I want to check and the row of the range that I want to check from different cells in the current sheet. For example, say that I want to check the range in columns G:I, but only for a row whose value is located in cell A1 of my current sheet, in a sheet whose name is located in cell B1 of my current sheet. So, if A1 = 15 and B1 = “Sheet2” my formula in cell C1 would tell me whether the range G15:I15 in Sheet2 is null. I’ve played around a lot with the Indirect and Index functions in trying to figure this out, but I can’t seem to find a syntax that will work. I’ve managed to get it to work if I hardcode either the sheet name or the row number, but I want to avoid having to do either. Is this possible? Based on what I’ve tried so far, I feel like it has to be, I just haven’t found it yet. Any suggestions?
You may also like
In this article, you’ll learn how to create an email alias and how to utilize it in the best way possible to […]
I’ve been asigned the task to resurrect a VMware 6.7 test server with a failed RAID 1 (and no backup, of course!). […]
E-commerce service provider, eBay Inc. (EBAY – Analyst Report) has agreed to acquire a Chinese mobile carrier billing payment company Zong for […]
Denver, CO, June 29, 2012 –(PR.com)– As one of the country’s leading developers of Magento, the number one shopping cart technology for […]