View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default search string command to answer simple Yes or No

I was looking for a solution for this one....

Main Page -

Have a single cell in which you would enter a single # into

2nd page -

import data file from another system that would have a table of numbers
all in a single column


After entering the number on page 1 of the spreadsheet it goes to the
2nd page, searches and if it finds the number gives back a result of
YES... and if it fails NO. Then show the results on the first page of
its findings...