Can this be done....?

"Dan B" wrote:
> Thanks for you help. This is partially working. Its just not pulling the
> data over on all rows. I noticed that there some differences in the
company
> names, i.e. some abbreviations etc, so it is not always finding an exact
> match. But, I fixed some of those, and it still didn't pull those over.
> Any ideas on that?

There could be extraneous white spaces (leading, in-between or trailing
spaces), which are throwing the matching off. We could try wrapping TRIM
around to improve the robustness of the matching.

Try instead in G2, array-entered:
=IF(ISNA(MATCH(1,(TRIM(Sheet1!$A$2:$A$100)=TRIM($A2))*(TRIM(Sheet1!$L$2:$L$1
00)<>""),0)),"",INDEX(TRIM(Sheet1!B$2:B$100),MATCH(1,(TRIM(Sheet1!$A$2:$A$10
0)=TRIM($A2))*(TRIM(Sheet1!$L$2:$L$100)<>""),0)))

(copy to I2, amend I2, then re-fill the formula as before)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

That made a big difference. I think the rest is just getting exact matches
in the company names. I'll just have to fix those manually. Thank you for
your expertise. I wish I knew Excel as well as you!

Thanks again,

Dan



"Max" <demechanik@yahoo.com> wrote in message
news:eXNpLqcLGHA.3064@TK2MSFTNGP10.phx.gbl...
> "Dan B" wrote:
>> Thanks for you help. This is partially working. Its just not pulling
>> the
>> data over on all rows. I noticed that there some differences in the
> company
>> names, i.e. some abbreviations etc, so it is not always finding an exact
>> match. But, I fixed some of those, and it still didn't pull those over.
>> Any ideas on that?
>
> There could be extraneous white spaces (leading, in-between or trailing
> spaces), which are throwing the matching off. We could try wrapping TRIM
> around to improve the robustness of the matching.
>
> Try instead in G2, array-entered:
> =IF(ISNA(MATCH(1,(TRIM(Sheet1!$A$2:$A$100)=TRIM($A2))*(TRIM(Sheet1!$L$2:$L$1
> 00)<>""),0)),"",INDEX(TRIM(Sheet1!B$2:B$100),MATCH(1,(TRIM(Sheet1!$A$2:$A$10
> 0)=TRIM($A2))*(TRIM(Sheet1!$L$2:$L$100)<>""),0)))
>
> (copy to I2, amend I2, then re-fill the formula as before)
> --
> Max
> Singapore
> http://savefile.com/projects/236895
> xdemechanik
> ---
>
>

Glad it helped, Dan !
Thanks for the feedback ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Dan B" <none@none.com> wrote in message
news:#orWpWdLGHA.208@tk2msftngp13.phx.gbl...
> That made a big difference. I think the rest is just getting
> exact matches in the company names.
> I'll just have to fix those manually.
> Thank you for your expertise. I wish I knew Excel as well as you!
>
> Thanks again,
>
> Dan