View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Steve Crombie Steve Crombie is offline
external usenet poster
 
Posts: 2
Default Lookup a row and column and return value

Hi Carim,

Thank you, this worked a treat.

Best regards,

Steve.

"Carim" wrote in message
oups.com...
Hi Steve,


Say you are inputing in cell E1 : 178 and in cell F1 : 20% , in your
result cell type:

=INDEX(A1:C4,MATCH(E1,A1:A4),MATCH(F1,A1:C1))

HTH
Cheers
Carim