#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,856
Default 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...


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
VLookUp - Does the VLookUp return the exact information? Cpviv Excel Worksheet Functions 2 October 28th 08 09:57 AM
Vlookup in vlookup - taking the result as array name SupperDuck Excel Worksheet Functions 2 June 2nd 07 11:05 AM
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP buffgirl71 Excel Discussion (Misc queries) 12 November 14th 06 11:36 PM
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) MikeR-Oz New Users to Excel 1 March 22nd 06 09:01 AM
Vlookup info being used without vlookup table attached? Excel Worksheet Functions 0 January 25th 05 10:43 AM


All times are GMT +1. The time now is 11:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"