Hi
Question 1: You can't achieve this in the SAME cell with formulas. This
requires VBA. Maybe the following is what you're looking for (using a
listbox + VBA Code)
http://www.contextures.com/excelfiles.html
search for: Data Validation "Columns"
Question 2:
Where do you have these combinations tored (column C of your table?) Or
how is this calculated?
--
Regards
Frank Kabel
Frankfurt, Germany
"wuwu" schrieb im Newsbeitrag
...
I have two questions.
First,
See the below data.
123456 BOOKA
234555 BOOKB
345678 BOOKC
848599 BOOKD
111100 BOOKE
758844 BOOKF
877290 BOOKG
585858 BOOKH
I want : When I type 123456 in a cell, the cell will be changed to
BOOKA
automatically. When I type 234555, the cell will be changed to
BOOKB.........
How can do this request using IF fuction or vLOOKUP
Question 2.
How can I use IF or other functions to do ........
I have data in cell A1 (123456), and B1 (500pcs)
now, I would like to use IF or other functions to set that If A1
=123456 and
B1= 500pcs, C1 would be shown 20KGS automatically.
--
wuwu