Thread: Find in a Grid
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Stanley
 
Posts: n/a
Default Find in a Grid

I have a grid that has numbers across the top and the same numbers down the
left side. I need to be able to lookup the numbers given by the user and show
the results of the search on the page. I need to have the grid on a hidden
page and the search on the first sheet. I know I could put them into columns
saying something like

colA colB colC
1 1 Yes
1 2 No
1 3 Yes
2 1 Yes
etc...

But you can see how much more work that would be since the grid is already
done. Any ideas?

Stanley