Lookup

[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?

 

[Michael]

Hi Bob
Assuming your row is cells A9:J9
and
Your Column is Cells D514
use
=SUM(A9:J9 D514)

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

Regards
Michael