need to lookup a value in one column to fill in another
I have only 4 columns in a log book, the first is the Customer name the
second is the customer number, the other two are some date columns. I've
been manually entering the customer name and number for the past year. I
want to be able when adding a new row to type in the customer number and it
will lookup above to find the customer name. is there anyway to do this?
thanks
|