Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return value based on criteria | Excel Discussion (Misc queries) | |||
Return info based on 1 criteria | Excel Discussion (Misc queries) | |||
Return a value based on two criteria | Excel Discussion (Misc queries) | |||
Return number OR sum based on two criteria | Excel Worksheet Functions | |||
return value based on two criteria | Excel Worksheet Functions |