| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
search for data matching some condition
For example,
Sheet 1 is data base as below. name group team ------ ------ ------ aaa red bear bbb blue lion ccc red lion ddd yellow tiger eee blue bear ..... Now I want to fill up sheet 2 using sheet 1 name group team ------ ------- ------ ccc eee hhh How can I find match group name and team name in sheet 1? What function is working for searching. There is no duplicated name in data base. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Discussion (Misc queries) | |||
| Search & match more than one worksheet and matching cells. | Excel Worksheet Functions | |||
| Matching data and linking it to the matching cell | Links and Linking in Excel | |||
| Finding the cell reference of a matching search value | Excel Worksheet Functions | |||
| how to search in excel with condition | Excel Discussion (Misc queries) | |||
Threaded Mode
