Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
A continuing search
Guys,
I am hopeless as hell with the right lingo or wording when it comes to excel so apologies if i lose you. What I am need to do is the following. Sheet1 has 10 cells on 2 rows. Row 1 is just labling, plays no part what so ever. Row 2 is what i call the "Search Input" row. What I am wanting to do is if I put a word in to any one of the 10 "Search Input" cells, it will return the closest results on the same sheet along with other data that is found on the same rows in Sheet2. Sheet2 contains all the data, itself has 15 rows. When I type any text in any one of the "Search Input" cells on Sheet1, it will input all 15 rows of data from Sheet2 in to sheet1 some 5 rows down frmo the Search Input rows. If i was to type only part of some text in to a or any one of the Search Input cells, it would result multiple results in the 6 rows down and beyond. I am now doubt asking to much but i have given up with VLookup and sumif :( Cheers guys, Steve. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
A continuing search
WeSky,
I don't have an answer for you regarding this specific question but it sounds you are looking for WILDCARD CHARACTERS WITH VLOOKUP. I wish I could be more insightful but I have been wondering about this my self during my last 2 years a Excel Developer. Going to keep an eye out for any feedback anyone leaves you as I hope someone finally does answer this annoying issue. Best of luck man...you might want to consider doing a search in the groups for "EXCEL WILDCARD VLOOKUP". The santax of the responces people left for comments similar to yours isn't explained very well and I couldn't figure it out for the life of me but maybe you might have better luck... -Todd weSky wrote: Guys, I am hopeless as hell with the right lingo or wording when it comes to excel so apologies if i lose you. What I am need to do is the following. Sheet1 has 10 cells on 2 rows. Row 1 is just labling, plays no part what so ever. Row 2 is what i call the "Search Input" row. What I am wanting to do is if I put a word in to any one of the 10 "Search Input" cells, it will return the closest results on the same sheet along with other data that is found on the same rows in Sheet2. Sheet2 contains all the data, itself has 15 rows. When I type any text in any one of the "Search Input" cells on Sheet1, it will input all 15 rows of data from Sheet2 in to sheet1 some 5 rows down frmo the Search Input rows. If i was to type only part of some text in to a or any one of the Search Input cells, it would result multiple results in the 6 rows down and beyond. I am now doubt asking to much but i have given up with VLookup and sumif :( Cheers guys, Steve. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Continuing functions | Excel Discussion (Misc queries) | |||
Continuing Formula - try 3 | Excel Discussion (Misc queries) | |||
Continuing Headers | Excel Discussion (Misc queries) | |||
Continuing Macro | Excel Discussion (Misc queries) | |||
Continuing Question | Excel Programming |