A | B | C | D | E | F | |
Dropbox1 | Dropbox2 | |||||
Select | 0 | |||||
peaches | fresh | |||||
pears | Frozen | |||||
<tbody>
</tbody>
I have 2 drop boxes as above. When I select pears from DB#1, I want frozen to appear in box 2 automatically. Or if I select peaches I want fresh to appear. that simple...........not for me lol
I have tried vlookup index match WHAT IS IT!!!!!!!!!
On another sheet called Specs in column A is fruit column B is condition
A | B | |||
Fruit | Condition | |||
Select | 0 | |||
peaches | fresh | |||
pears | frozen | |||
<tbody>
</tbody>