G

#### Guest

We have another worksheet cell, where we want to use the value of the VLOOKUP result as part of an array formula

Unfortunately, it ignores the result and our formula doesn't work

For exampl

Contract ABC has a value of '9' in the VLOOKUP field. This value was VLOOKUP'd from a separate worksheet

We have an array formula that sums (counts occurrences) of all of those contracts that are for a specific office, and a specific dollar value that have this value '9'. However, this 9 isn't seen as a value and so, unless I then type over the '9' with a hard typed '9' the formula doesn't work

Is there another way I can accomplish this?