Thread: Check to see if a value exists in a list?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default Check to see if a value exists in a list?
=OR(INDEX(A1:A3=B2,))


"Pradhan" wrote:

Hi and thanks again for your help out there...
Is there any function to test if a particular value exists in a list?
A simple example: Column A1= car; A2=train; A3=plane

In B2 I place "car". Is there a function which will return TRUE if B2 exists
in A1:A3, or false otherwise?

Thanks
Pradhan
Reply With QuoteReply With Quote