Thread: I WANT FORMULA
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
vikram mundra vikram mundra is offline
external usenet poster
 
Posts: 5
Default I WANT FORMULA



"vikram mundra" wrote:



"Srinivas" wrote:

I have some similar values in a1:a100 and b1:b100

I want to find the value in a1 if there in B1:b100. If yes means i want to
display yes and no means "NO" in some cell in c

Which formula can i use