I have a worksheet consist of multiple Item Templates (Note that 1 template have different values) in in Column A and the item attributes in Column B to Column GD, I want to get the value of "NULL" per item template from Column B:GD. I tried the below formula but it doesn't give the correct value, actually it has an error.
For VLOOKUP() function, value which you search should be placed at the first column. Then your formula should be like this:
You can try the below formula, if your requirement is to find number of 'NULL' for 'Finished Goods' - I feel this is your requirement.