Thread: lookup matrix
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jack jack is offline
external usenet poster
 
Posts: 186
Default lookup matrix

I have the following matrix. I'm given the values of C and bb
How would i write a macro to get the result? which is 8.

aa bb cc
A 1 2 3
B 4 5 6
C 7 8 9
D 10 11 12
E 13 14 15

thanks
Jack