doing a search that returns a list??
Posted by CL0CKW0RK on January 09, 2001 12:13 PM
I need to be able do a text search of a worksheet that would return a list of every row in the worksheet which contained the searched text. Kind of a combination of "find" and "autofilter" that searched each column?
I know a little Visual Basic but ive never worked with it with Excel, is this something that i could write into the program? or is it out there somewhere already?
thanks any help would be apreciated.
Posted by Mark W. on January 09, 2001 12:16 PM
How many columns need to be searched?
Posted by CL0CKW0RK on January 09, 2001 12:52 PM
1 to 3, i have a few differnt files i need to do searches in. some have 2 columns that need searching others more. Im just looking for a way to do a simple search without haveing to do a custom autofilter on each column with "contains" selected, remove the filter and then filter the next column.
?
Posted by Mark W. on January 09, 2001 1:46 PM
Do you know how to use Advanced Filters?
Posted by Mo on January 09, 2001 2:51 PM
Hello there, you might want to use Vlookups. Once you have written the formula, fill it to the right. Once you have put this formula, just drag to the right if you want to include an extra column. Sometime for some reason, this wouldn't work when you drag to the right. When that happens, refference the cells as absolute, and keep changing the column number. in this case the column number is 2, for the third column put 3, for 4th put four. Below I15:J15 is the table range, & E15 is the place you would put your search value.
best of luck.
VLOOKUP(E15,I15:J15,2,FALSE)
