Thread: Find item in list, return a value
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Ladymuck Ladymuck is offline
external usenet poster
  
Posts: 45
Default Find item in list, return a value
Works a treat, thank you!

"Bob Phillips" wrote:

=IF(ISNUMBER(MATCH(A2,Sheet1!A:A,0)),"APPROVED",IF (ISNUMBER(MATCH(A2,Sheet1!B:B,0)),"NOT
APPROVED",""))

and copy down.

--
---
HTH

Bob


Reply With QuoteReply With Quote