Hi,
Wanting to figure out how to write an excel formula to return value from an array of 5 items in which it is a "value" in column A and matches "green dot" text in column B.
In below manual example, cell E2 would return 33.7.
Wanting to figure out how to write an excel formula to return value from an array of 5 items in which it is a "value" in column A and matches "green dot" text in column B.
In below manual example, cell E2 would return 33.7.