Thread: Intersection
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Excel User 123456 Excel User 123456 is offline
external usenet poster
 
Posts: 4
Default Intersection

I am trying to see what the value in column A would be where column B and C
are equal. Here is my data:

A B C
$100,000 $88,010 $(88,957)
$105,000 $74,248 $(74,149)
$110,000 $60,485 $(59,341)
$115,000 $46,722 $(44,533)
$120,000 $32,960 $(29,726)
$125,000 $19,197 $(14,918)
$130,000 $5,435 $(110)
$135,000 $(8,328) $14,698
$140,000 $(22,090) $29,506
$145,000 $(35,853) $44,314

Any suggestions?