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
I use neovim and neovim-lsp-config with clangd. The default keybind for code actions is <space>ca, after pressing which a menu pops up. […]
submitted by /u/leemcd56 [link] [comments]
my Macbook Pro is now running Ventura 13.5 I am no longer able to use the AFT app (android file transfer) to […]
The URL is this: https://software-download.microsoft.com/db/Win10_21H1_English_x64.iso?t=52dbec9b-63f5-47e9-b4b2-ccbcbb6beb7a&e=1627124449&h=42e9a2a8e1f843e5a4573960dc07feaa The error is: –2021-07-24 00:07:57– https://software-download.microsoft.com/db/Win10_21H1_English_x64.iso?t=52dbec9b-63f5-47e9-b4b2-ccbcbb6beb7a Resolving software-download.microsoft.com (software-download.microsoft.com)… 117.18.232.200 Connecting to software-download.microsoft.com (software-download.microsoft.com)|117.18.232.200|:443… connected. HTTP request […]