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
|