RAMatgreenleaf
Board Regular
- Joined
- Sep 23, 2005
- Messages
- 84
i can get it to show the value from 1 cell in the cell, but is it possible to pull the value from 2
i have a box saying what type of pavers are to be used
and a box showing how many sqare feet of pavers are to be installed
and i have
=J64& " sf of blue stone are to be installed"
this show the value of square feet of blue stone is to be installed
but where it says blue stone, i want it to grab a value of another cell, cell =G6 because that is a dropdown menue which lets me select which type of paver i want to use
so i want it to take the value of sqare feet and the type of brick
so it will say example of...
755 square feet of couventry3 are to be installed
where the 755 is value J64, and the coventry3 is value G6
thank you
i have a box saying what type of pavers are to be used
and a box showing how many sqare feet of pavers are to be installed
and i have
=J64& " sf of blue stone are to be installed"
this show the value of square feet of blue stone is to be installed
but where it says blue stone, i want it to grab a value of another cell, cell =G6 because that is a dropdown menue which lets me select which type of paver i want to use
so i want it to take the value of sqare feet and the type of brick
so it will say example of...
755 square feet of couventry3 are to be installed
where the 755 is value J64, and the coventry3 is value G6
thank you