Lookup

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

What formula should be used to look up the value of a
cell that is the intersection of a row and a column. Ex

1 50 75 44 22
2 3 4 6 9
3 1 32 5 66
4 2 44 6 8

To display the value at the intersection of 75 and 3?
 
Hi Bob
Assuming your row is cells A9:J9
and
Your Column is Cells D5:D14
use
=SUM(A9:J9 D5:D14)

When you type in the ranges make sure there is a single
space between them

Regards
Michael
 
Back
Top