Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do i use the If function to Lookup in a chart
I am using Excel 2007. My chart looks like this:
A B C 1 2 1 1 .5 ? .5 8 9 1 9 10 I want to use the values in A1 & B1 to generate the appropriate reference in C1. So if A1=1 and B1=.5, then C1 should equal the value in the appropriate cell in the second table. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do i use the If function to Lookup in a chart
I'm guessing that you want the value at the intersection of 1 (A1) and 0.5
(B1). With your table in the range E1:G3... =VLOOKUP(B1,E1:G3,MATCH(A1,E1:G1,0),0) Returns 8. -- Biff Microsoft Excel MVP "kethrydrake" wrote in message ... I am using Excel 2007. My chart looks like this: A B C 1 2 1 1 .5 ? .5 8 9 1 9 10 I want to use the values in A1 & B1 to generate the appropriate reference in C1. So if A1=1 and B1=.5, then C1 should equal the value in the appropriate cell in the second table. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to combine an IF Function with a lookup function to determine | Excel Worksheet Functions | |||
Changing Chart with a lookup | Charts and Charting in Excel | |||
Help using lookup function | Excel Discussion (Misc queries) | |||
Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) | |||
Lookup Function? | Excel Worksheet Functions |