I have one cell in which I have applied data validation rules. When the users selects one of the permitted options I want to update the values of 3 other cells (automatically). Is there any way to achieve that?
Automatic update cell based on the values of another cell
-
-
-
Re: Automatic update cell based on the values of another cell
Update then how? Are you looking up items in a table?
-
Re: Automatic update cell based on the values of another cell
Please refer to attachment
forum.ozgrid.com/index.php?attachment/56818/ -
Re: Automatic update cell based on the values of another cell
I can't see any data validation applied.. only cell comments.. are the cell comments what you wish your data val would be?
-
Re: Automatic update cell based on the values of another cell
I think you want in C3:
=IF($A3="","",VLOOKUP($A3,$G$3:$I$4,2,0))
and in D3
=IF($A3="","",VLOOKUP($A3,$G$3:$I$4,3,0))
the bolded number is the column number in the table to extract from.
-
-
Re: Automatic update cell based on the values of another cell
This is was I was looking for! I hadn't realised it was so easy...
Thank you very much!
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!