Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
if search
Assuming that data occupies A1:E5, and that you want to use G1 to
select the column number, enter this in G3: =IF(ISNA(MATCH(G$1,A$1:E$1,0)),"",INDEX($A3:$E3,(M ATCH(G$1,A$1:E $1,0))) then copy this into G4 and G5. This would work for any identifier in A1:E1 and G1. A slightly simpler version would be: =IF(OR(G$1<1,G$15),"",INDEX($A3:$E3,G$1)) Hope this helps. Pete On Oct 1, 3:23*pm, Jase wrote: *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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
if search
That is helping but I forgot that i may not be looking for exact matches.
What I enetered 2.6, I would want it to return the closest data match in this case being 3. Any help on that? thanks, Jase "Pete_UK" wrote: Assuming that data occupies A1:E5, and that you want to use G1 to select the column number, enter this in G3: =IF(ISNA(MATCH(G$1,A$1:E$1,0)),"",INDEX($A3:$E3,(M ATCH(G$1,A$1:E $1,0))) then copy this into G4 and G5. This would work for any identifier in A1:E1 and G1. A slightly simpler version would be: =IF(OR(G$1<1,G$15),"",INDEX($A3:$E3,G$1)) Hope this helps. Pete On Oct 1, 3:23 pm, Jase wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
if search
Okay then, you could do this:
=IF(OR(G$1<1,G$15),"",INDEX($A3:$E3,ROUND(G$1,0)) ) Hope this helps. Pete On Oct 1, 4:51*pm, Jase wrote: That is helping but I forgot that i may not be looking for exact matches. What I enetered 2.6, I would want it to return the closest data match in this case being 3. Any help on that? thanks, Jase "Pete_UK" wrote: Assuming that data occupies A1:E5, and that you want to use G1 to select the column number, enter this in G3: =IF(ISNA(MATCH(G$1,A$1:E$1,0)),"",INDEX($A3:$E3,(M ATCH(G$1,A$1:E $1,0))) then copy this into G4 and G5. This would work for any identifier in A1:E1 and G1. A slightly simpler version would be: =IF(OR(G$1<1,G$15),"",INDEX($A3:$E3,G$1)) Hope this helps. Pete On Oct 1, 3:23 pm, Jase wrote: *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- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Seo , Search Engine Optimizer , Seo Search engine Optimization , search engine optimization services, SEO Consulting | Excel Worksheet Functions | |||
Seo , Search Engine Optimizer , Seo Search engine Optimization , search engine optimization services, SEO Consulting | Excel Discussion (Misc queries) | |||
Seo , Search Engine Optimizer , Seo Search engine Optimization , search engine optimization services, SEO Consulting | Links and Linking in Excel | |||
Seo , Search Engine Optimizer , Seo Search engine Optimization , search engine optimization services, SEO Consulting | Charts and Charting in Excel | |||
How do I search excel spreadsheets using multiple search criteria. | Excel Worksheet Functions |