View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Katie Katie is offline
external usenet poster
 
Posts: 130
Default V LOOK UP AND IF STATEMENT

I want to use a vlookup and if statement to return a value of Y if found and
N if not found i.e. look up the value in column a in another spreadsheet and
put N if not found and Y if found