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
"Roger" 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

Sunny

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

Adjust range to your needs.

HTH
--
AP

"DB Explorer" a écrit dans le message de
oups.com...
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
"Roger" 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

Sunny

=VLOOKUP(A2,[OtherFileName.xls]Sheet1!B:C,2,FALSE)

Vaya con Dios,
Chuck, CABGx3



"DB Explorer" wrote:

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
"Roger" 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

Sunny

Thanks !! This works great.