software

Hi

I need help with this please.

I have an excel sheet which gets data pasted onto it, on the basis of
top 5 ranks for that day.

Like This:

A B C
Roger 50
James 45
Donand 30
Jeremy 29
Sophia 28

Now, I have another workbook, with 50 such names on it, with monthly
data in it. How do I have Cell C2 display the Monthly data for Roger?
i.e, there needs to be a formula on C2 which searches for the name
quot;Rogerquot; in another file's B column, and display the corresponding C
column value here.

Sorry, I have tried best to make the question sound sensible. Would
appreciate any help on this.

Cheers

SunnyIn C2:
=VLOOKUP(A2,Sheet2!B2:C999,1,FALSE)

Adjust range to your needs.

HTH
--
AP

quot;DB Explorerquot; gt; a écrit dans le message de oups.com...
gt; Hi
gt;
gt; I need help with this please.
gt;
gt; I have an excel sheet which gets data pasted onto it, on the basis of
gt; top 5 ranks for that day.
gt;
gt; Like This:
gt;
gt; A B C
gt; Roger 50
gt; James 45
gt; Donand 30
gt; Jeremy 29
gt; Sophia 28
gt;
gt; Now, I have another workbook, with 50 such names on it, with monthly
gt; data in it. How do I have Cell C2 display the Monthly data for Roger?
gt; i.e, there needs to be a formula on C2 which searches for the name
gt; quot;Rogerquot; in another file's B column, and display the corresponding C
gt; column value here.
gt;
gt; Sorry, I have tried best to make the question sound sensible. Would
gt; appreciate any help on this.
gt;
gt; Cheers
gt;
gt; Sunny
gt;
=VLOOKUP(A2,[OtherFileName.xls]Sheet1!B:C,2,FALSE)

Vaya con Dios,
Chuck, CABGx3
quot;DB Explorerquot; wrote:

gt; Hi
gt;
gt; I need help with this please.
gt;
gt; I have an excel sheet which gets data pasted onto it, on the basis of
gt; top 5 ranks for that day.
gt;
gt; Like This:
gt;
gt; A B C
gt; Roger 50
gt; James 45
gt; Donand 30
gt; Jeremy 29
gt; Sophia 28
gt;
gt; Now, I have another workbook, with 50 such names on it, with monthly
gt; data in it. How do I have Cell C2 display the Monthly data for Roger?
gt; i.e, there needs to be a formula on C2 which searches for the name
gt; quot;Rogerquot; in another file's B column, and display the corresponding C
gt; column value here.
gt;
gt; Sorry, I have tried best to make the question sound sensible. Would
gt; appreciate any help on this.
gt;
gt; Cheers
gt;
gt; Sunny
gt;
gt;

Thanks !! This works great.