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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
search for data matching some condition
You can use the Vlookup function. Something like this...
=vlookup(A2, Sheet1!$A$2:$C$10, 2, false) -- HTH... Jim Thomlinson "Michael Hahn" wrote: 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
search for data matching some condition
Thank you very much!
I tested and it works. You are the best. "Jim Thomlinson" wrote: You can use the Vlookup function. Something like this... =vlookup(A2, Sheet1!$A$2:$C$10, 2, false) -- HTH... Jim Thomlinson "Michael Hahn" wrote: 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. |
Reply |
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) |