Prev: Macro to build table
Next: SumProduct Between Dates
From: burtlake on 27 May 2010 17:41
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



From: Steve Dunn on 28 May 2010 10:22
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" <burtlake(a)discussions.microsoft.com> wrote in message
news:BD8B6C6D-4110-4C43-B135-E4D4D17D056F(a)microsoft.com...
>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
>
>
>

 | 
Pages: 1
Prev: Macro to build table
Next: SumProduct Between Dates