View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
TechieGirl TechieGirl is offline
external usenet poster
 
Posts: 10
Default Need Function Help

Hi,

I have looked up the search, vlookup, insa and if functions and I am still a
little lost. I need a funtion that will look up a value or cell in a column
and return true or false.
Basically, if (the value of A1 is equal to any value in C:C then True,False)

Like so:
A B C
1 Monday January FALSE
2 Tuesday Thursday TRUE
3 Wednesday March FALSE
4 Thursday Tuesday TRUE
5 Friday May FALSE
6 Saturday Saturday TRUE
7 Sunday July FALSE