Thread: does range value exist in another range
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Spencer Spencer is offline
external usenet poster
  
Posts: 29
Default does range value exist in another range
is there a simple macro i can run to determine if the value in range("B5")
exists anywhere in range("A1:A10").
similar to the excel function
=MATCH(B5, A1:A10,0)
TIA.
Reply With QuoteReply With Quote