PDA

View Full Version : copying information from another tab



antonyjones1
10-18-2009, 01:11 AM
In the attached spreadhseet i want to pull out information from the master sheet tab and put it into the workings tab if certain words are in the column next to it.

So for example I have manually Put in the markup % in Column A and the 1 unit tt value in column C. What I want is column a and c to automatically update when I input information into B. What would the easiest way to do this? Would vlookup be the best way? All suggestions and examples welcome :)

mdmackillop
10-18-2009, 01:50 AM
Use VLookup with Data Validation