Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Selecting Cells
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 Two |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Selecting Cells
I 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("5/19",$A$2:$E$6,4,FALSE) Instead of "5/19" 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. "BiggyTwo" wrote: 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 Two |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking Groups of cells between workbooks | Excel Discussion (Misc queries) | |||
selecting non adjacent cells | Excel Worksheet Functions | |||
selecting cells | Excel Discussion (Misc queries) | |||
Hightlighting crosshairs when selecting cells | Excel Discussion (Misc queries) | |||
To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) |