Thread: How do I validate text in a cell based on other sheets in the work
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
carlo carlo is offline
external usenet poster
  
Posts: 367
Default How do I validate text in a cell based on other sheets in thework
Did you try a formula like:
=OR(NOT(ISERROR(VLOOKUP(A1,Sheet2!
A1:A4,1,FALSE))),NOT(ISERROR(VLOOKUP(A1,Sheet3!
A1:A4,1,FALSE))),NOT(ISERROR(VLOOKUP(A1,Sheet4!A1: A4,1,FALSE))))

this gives you a FALSE if the word in A1 does not exist, or a TRUE if
it does exist.

Maybe that puts you on the right path.

Cheers Carlo
Reply With QuoteReply With Quote