Thread: if search
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jase jase is offline
external usenet poster
 
Posts: 117
Default if search

I want to be able to do some sort of "If Search" that will allow me to to
change my search criteria. For example if I specify that I want the data in
the 5 column of my data table below it will grab that data below it through
some kind of if link. SO if in a cell i type 4, below it in the next rows it
will give me the data of the 4th point.

Any idea if that is possible or if I am even making any sense?

1 2 3 4 5

..2 .3 .1 .3 .6
..4 .2 .8 .4 .7
..9 .7 .1 .2 .8

thanks,

Jase