D
DB Explorer
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
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