LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
C. C. is offline
external usenet poster
 
Posts: 14
Default Return value based on certain criteria

Hi all,

I have two separate worksheets within the same workbook

The first worksheet (ConsultCall!) looks like this:

ID# Percentage

1-1232 50%
2-345 61%
10-12 89%
15-98753 25%

In another sheet (Calc!), I have a similar ID# column, but the ID #'s
are not in the same order as the first worksheet and some ID #'s are
in one that are not in the other column. Basically I want to be able
to match on unique ID #'s and then return the corresponding percentage
value in another column in the second worksheet for that ID # in the
first worksheet.

ID#
15-98753
10-12
2-345

Any thoughts? Thanks!
 
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
Return value based on criteria andiam24 Excel Discussion (Misc queries) 0 April 21st 09 01:48 PM
Return info based on 1 criteria John Moore Excel Discussion (Misc queries) 5 September 17th 08 01:02 PM
Return a value based on two criteria cdavidson Excel Discussion (Misc queries) 1 April 5th 07 07:35 PM
Return number OR sum based on two criteria John in MN Excel Worksheet Functions 2 July 26th 06 02:23 PM
return value based on two criteria blopreste3180 Excel Worksheet Functions 3 January 16th 06 02:15 PM


All times are GMT +1. The time now is 12:55 AM.

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

About Us

"It's about Microsoft Excel"