The result will be exactly like shown in the screenshot above.
How to return different results based on cell valueIn case you want to compare each cell in the target column against another list of items and return a different value for each match, use one of the following approaches.