Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to look up values with two independent variables
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to look up values with two independent variables
=INDEX(rng3,MATCH(1,(rng1=val1)*(rng2=val2),0))
-- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "charlesfung" wrote in message ... |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to look up values with two independent variables
Many of us will not respond to a post where you don't take the time to fully
explain your problem in the body of the post instead of a simple subject line. -- Don Guillett SalesAid Software "charlesfung" wrote in message ... |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to look up values with two independent variables
Bob, of course, is the exception.
-- Don Guillett SalesAid Software "Don Guillett" wrote in message ... Many of us will not respond to a post where you don't take the time to fully explain your problem in the body of the post instead of a simple subject line. -- Don Guillett SalesAid Software "charlesfung" wrote in message ... |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to look up values with two independent variables
.... an .... <g
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Don Guillett" wrote in message ... Bob, of course, is the exception. -- Don Guillett SalesAid Software "Don Guillett" wrote in message ... Many of us will not respond to a post where you don't take the time to fully explain your problem in the body of the post instead of a simple subject line. -- Don Guillett SalesAid Software "charlesfung" wrote in message ... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
RE-submitting of: constructing (complex) variables with worksheet functions | Excel Worksheet Functions | |||
Count Intervals of 2 Consecutive Values in same Row and Return Count across Row | Excel Worksheet Functions | |||
I Need a formula to evaluate a cell with + or - values | Excel Worksheet Functions | |||
Return Range of Numerical Values in Single Column based on Frequency Percentage | Excel Worksheet Functions | |||
#N/A Values : Returned by Formulas vs Entered Manually | Charts and Charting in Excel |