Thread: lookup single value in a range and return specified value
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bjw bjw is offline
external usenet poster
  
Posts: 12
Default lookup single value in a range and return specified value
I have a value in A9 that i want to look up in range B2:B6 and return an X if
it is there and blank if it is not. How?

Reply With QuoteReply With Quote