Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find value based on two criteria
How would I write a formula to find the value in column C based on the values
of both column A and B? My table looks like this: A B C Month Year Price 7 2009 15.46 8 2009 15.98 9 2009 16.01 10 2009 16.23 11 2009 16.78 12 2009 17.09 1 2010 17.87 2 2010 17.98 and so on... So I want to find the price when A=7 and B=2009. Thanks so much for your help! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find criteria based data and display next to a count in another wk | Excel Discussion (Misc queries) | |||
How do I find and copy rows based on specific criteria? | New Users to Excel | |||
Query criteria based on a changing criteria list | Excel Discussion (Misc queries) | |||
find a value in a table based on 2 different criteria | Excel Worksheet Functions | |||
find minimum of range based on multiple criteria | Excel Worksheet Functions |