explorious
New Member
- Joined
- Mar 16, 2002
- Messages
- 3
the column headings are in row 1.ie d1,e1,f1,g1,....etc.the numbers are in column d2,d3,d4,...etc.For example,if i type a name of a column heading into cell a1 and type a number into a2,how do i get the value(returned in cell a3) where column and row meet.ie. look along row 1 for value (typed in a1)then look down column d for value typed in a2.return value into a3 of the cell
where both column and row meet.
the ap
This message was edited by explorious on 2002-03-17 20:17
where both column and row meet.
the ap
This message was edited by explorious on 2002-03-17 20:17