Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Two Level Search
I have simplified the example ----- I would like to search the table shown
below and determine the amount Pledge by each family. However since there are last names that are the same, a simple vlookup does not work. For example, I must define my search so I get Bill Johnson, not Frank Johnson. For the example, I would like the search result to appear in the column labeled "Search Result". Fund Raiser Invitations and Followup Roberts 22-May Y/N Invited Attended Pledged (amount) Search Result Smith Bill Marla N 1000 Smith Jon Sue N 12500 Johnson Bill Carla N 550 Johnson Frank Norma Y 4000 Johnson John Nancy Y 3300 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Two Level Search
I'm not entirely clear what you want here, does this do what you need?
=index($E$1:$E$5,match(1,($A$1:$A$5="Johnson")* ($B$1:$B$5="Bill Carla"),0) "burtlake" wrote in message ... I have simplified the example ----- I would like to search the table shown below and determine the amount Pledge by each family. However since there are last names that are the same, a simple vlookup does not work. For example, I must define my search so I get Bill Johnson, not Frank Johnson. For the example, I would like the search result to appear in the column labeled "Search Result". Fund Raiser Invitations and Followup Roberts 22-May Y/N Invited Attended Pledged (amount) Search Result Smith Bill Marla N 1000 Smith Jon Sue N 12500 Johnson Bill Carla N 550 Johnson Frank Norma Y 4000 Johnson John Nancy Y 3300 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Two Level Search | Excel Worksheet Functions | |||
Functions (search within search result) reply to this please | Excel Worksheet Functions | |||
Zoom level | Excel Discussion (Misc queries) | |||
Zoom level | Excel Discussion (Misc queries) | |||
How do I search excel spreadsheets using multiple search criteria. | Excel Worksheet Functions |