Thread: Function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
rajpoot_jee rajpoot_jee is offline
external usenet poster
 
Posts: 1
Default Function

Hi,

A B C D
1 150 300 450 600
2 2 20 50 70 80
3 4 40 60 90 100
4 6 60 80 100 120
5 8 80 110 130 150


How I can assign a function to get the value of 2 - 150 in Cell E2 IF I type
2 in cell F2 & 150 in cell F3