Searching for a value in a spreadsheet

[chris86t]

I want to find a specific occurance of a name in an external spreadsheet. Below is an example

A B C
1 Johnson Frank 10%
2 Dowers Chris 12%
3 Johnson Dan 20%

I need to be able to find Dan Johnson and get the data in column C. I can't modify the original spreadsheet. The names will change rows from week to week. Vlookup only finds the first occurance. What else can I try?

 

[SkipVought]

Hi,

I'd use MA Query.

faq68-5829

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[macropod]

Hi Chris,

Take a look at the the formulae in the attachments to my posts at:

http://www.techsupportforum.com/mic...fice-support/375768-excel-formula-issues.html

The same approach can be taken with external data.

Cheers

[MS MVP - Word]