View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kethrydrake kethrydrake is offline
external usenet poster
 
Posts: 1
Default 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.