vlookup
 

FSB core WPP(sum) WPP(Package)
C0 C1 C2 C3 C4 C5 C6
800 1200 77 51.5 0.00 0.01 48.00 0.00 0.00 0.00
801 1900 50 36.4 0.00 0.00 64.00 0.00 0.00 0.00
1067 1900 48.1 35.4 0.00 0.00 64.00 0.00 0.00 0.00
1068 2400 40.9 30.6 0.00 0.00 69.00 0.00 0.00 0.00


FSB_comp 800 Core_comp 1900

c1_comp =? c2_comp=? c3_comp =?


I want to compare FSB_comp value to FSB column and Core_comp value to Core column..from the row where we find the matches for core and fsb values I want to copy the residency values to c1_comp,c2_comp....



EggHeadCafe - Software Developer Portal of Choice
A Dynamic Progress Bar for Your ASP Page
http://www.eggheadcafe.com/tutorials...ss-bar-fo.aspx

vlookup
 

In your example you don't have any matches, so what should the answer
(s) be?

Pete

On Oct 9, 6:29*pm, poornima hk wrote:
FSB * * core * *WPP(sum) * * * *WPP(Package) * * * * * * * * * * * * * * * * * * * * * *
* * * * * * * * C0 * * * * * * *C1 * * *C2 * * *C3 * * *C4 * * *C5 * * *C6
800 * * 1200 * *77 * * *51.5 * *0.00 * *0.01 * *48.00 * 0.00 * *0.00 * *0.00
801 * * 1900 * *50 * * *36.4 * *0.00 * *0.00 * *64.00 * 0.00 * *0.00 * *0.00
1067 * *1900 * *48.1 * *35.4 * *0.00 * *0.00 * *64.00 * 0.00 * *0.00 * *0.00
1068 * *2400 * *40.9 * *30.6 * *0.00 * *0.00 * *69.00 * 0.00 * *0.00 * *0.00

FSB_comp * * * *800 * * * * * * Core_comp * * * 1900 * * * * * * * * * * * * * * * * * *

c1_comp =? *c2_comp=? * c3_comp =?

I want to compare FSB_comp value to FSB column and Core_comp value to Core column..from the row where we find the matches for core and fsb values I want to copy the residency values to c1_comp,c2_comp.... * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

EggHeadCafe - Software Developer Portal of Choice
A Dynamic Progress Bar for Your ASP Pagehttp://www.eggheadcafe.com/tutorials/aspnet/0f8083d1-4588-413d-a9dd-e...