Hi all.
I'm new at this site - have been looking through some questions/answers but I think I'm into a problem that can't be solved.
I have a Excel file with to separate sheets.
In the first sheet (data) I have 2 column's A with number B with tekst.
100 Cup
120 Tee
140 Good new
150 Old goods
160 office
170 used goods again
The other sheet (typing) is clean. But I would like to dedicate a column to lookup a value in the other sheet - lets say in column D.
For an example.
In sheet (typing) I would like to start typing "good" and I would like to get a list to choose from based on column B in sheet (data) the list should then show the possibilities (in this case "goods new", "old Goods" and "used goods again) I would then be able to choose one of the listed posts ... Is that possible in excel ?? Or am I asking too much database ??
I'm new at this site - have been looking through some questions/answers but I think I'm into a problem that can't be solved.
I have a Excel file with to separate sheets.
In the first sheet (data) I have 2 column's A with number B with tekst.
100 Cup
120 Tee
140 Good new
150 Old goods
160 office
170 used goods again
The other sheet (typing) is clean. But I would like to dedicate a column to lookup a value in the other sheet - lets say in column D.
For an example.
In sheet (typing) I would like to start typing "good" and I would like to get a list to choose from based on column B in sheet (data) the list should then show the possibilities (in this case "goods new", "old Goods" and "used goods again) I would then be able to choose one of the listed posts ... Is that possible in excel ?? Or am I asking too much database ??
