Current location - Recipe Complete Network - Complete cookbook of home-style dishes - If the text content entered in H5 is equal to any text content between B4 and B50 in another worksheet, then in I5?
If the text content entered in H5 is equal to any text content between B4 and B50 in another worksheet, then in I5?
Enter the following formula in I5:

=Index (another worksheet name $C$4: another worksheet name $C$ 14, match(H5, another worksheet name $B$4: another worksheet name $B$50).

The data range can be adjusted according to the actual situation.

You'd better press Ctrl+Shift+Enter to confirm, and you can't enter it directly.

The MATCH function returns the position of the specified number in the specified array area.

The INDEX function returns a value or a reference to a value in a table or range.