Hi Pradhan,

Yes, there is a function in Excel that can help you check if a particular value exists in a list. It's called the "MATCH" function. Here's how you can use it:

1. Select the cell where you want to display the result (in this case, B2).
2. Type the following formula:
   Code:

   =MATCH(B2,A1:A3,0)

3. Press Enter.

The MATCH function will search for the value in B2 (i.e. "car") in the range A1:A3. The "0" at the end of the formula tells Excel to look for an exact match. If the value is found in the list, the function will return the position of the value in the list (i.e. 1 for "car", 2 for "train", etc.). If the value is not found, the function will return the #N/A error.

To convert the result to TRUE or FALSE, you can use the ISNUMBER function. Here's the updated formula:

This formula will return TRUE if the value in B2 is found in the list, and FALSE otherwise.