View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rob Rob is offline
external usenet poster
 
Posts: 718
Default Urgent Formula Help Required

Hi

I am trying to work out a formula where say for example

A1 3
B1 2

In a different sheet I have a table that says for this combination it must
return a value of 8 in C1 any ideas anyone...There is a range of numbers I am
trying to return for different combinations based on a 5x5 matrix but its not
a simple A1xB1 to give me the solution.

any help would be of use