Function Help

  • Thread starter Thread starter lora
  • Start date Start date
L

lora

Would like to insert data from 12 different choices
without having to retype over and over.

I have a spreadsheet with over 100 worksheets. I have 12
text answers that I would like to be able to insert 1-12
in a specific column and the answer come up automatically.

for instance

1= found liquid in meter tube.

worksheet is the following columns
date - producer - number - violation
1 = (automatically inserts found
liquid in meter tube. or if I have many violations I would
like the cell to state the many violations.

lora thompson - 979-843-7204
 
I would add a sheet with just the 12 conditions you want
listed. Use two columns with the number in the first
column and the conditions listed in the second column.
Then in the fourth column of your worksheets use the
following: =if(A1="","",vlookup(c1,newsheet!a1:b12,2))
this will look at the cell a1, if blank, leaves the cell
d1 blank, but if there is a date in the first column, it
will use the vlookup function to match the condition in
column 3 to the data loaded in newsheet in the range
a1:b12 and return that text to column 4 in your original
spreadsheet.
Good luck.
 
Back
Top