software

Hi All,

I have a small spreadsheet, where A1 to E1 are headings, with columns
like this:

A B C D E
1 DATE Lime/g Alum/g Chlorine/g Carbon/g
2 5/19 200 360 135 600
4 .................................................. .......
5 .................................................. .......
6 9/19 230 300 225 450

Can I link the value in cell A2 to D2? (ie if A2 is chosen how can I
select D2, another cell in the same row, for use in a calculation.)

If anybody understands what I am trying to say I will be happy for
suggestions. (Otherwise just ignore, lest I confuse more than I am.)

Many thanks in advance.

Biggy TwoI suppose that you try to extract the value on column D based on the values
on column A. You can use VLOOKUP, for example:
=VLOOKUP(quot;5/19quot;,$A$2:$E$6,4,FALSE)
Instead of quot;5/19quot; you can use a cell reference, where you have a value to
search, and you can expand the range A2:E6 to match your particular case.
The formula will return the value on column D for the matching value on
column A.

Was this what you were asking?
Miguel.

quot;BiggyTwoquot; wrote:

gt; Hi All,
gt;
gt; I have a small spreadsheet, where A1 to E1 are headings, with columns
gt; like this:
gt;
gt; A B C D E
gt; 1 DATE Lime/g Alum/g Chlorine/g Carbon/g
gt; 2 5/19 200 360 135 600
gt; 4 .................................................. .......
gt; 5 .................................................. .......
gt; 6 9/19 230 300 225 450
gt;
gt; Can I link the value in cell A2 to D2? (ie if A2 is chosen how can I
gt; select D2, another cell in the same row, for use in a calculation.)
gt;
gt; If anybody understands what I am trying to say I will be happy for
gt; suggestions. (Otherwise just ignore, lest I confuse more than I am.)
gt;
gt; Many thanks in advance.
gt;
gt; Biggy Two
gt;
gt;