Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VLookUp - Does the VLookUp return the exact information? | Excel Worksheet Functions | |||
Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |