Forms toolbar Worksheet

[mick.whyte]

Hi

Realise I can use a VLookup for this but is there a way of returning
the selected value from a combo on a worksheet as opposed to the
index.

For instance a cbo populated by ted, bob, john returns '2' into the
link cell if 'bob' is selected. Is there a way of returning the actual
value?

Thanks

Mick

 

[Jim Rech]

The only way to do that is to use a combobox from the Control Toolbox
toolbar. Its linked cell returns the value not the index. I think I'd stay
with the Forms toolbar combo and use a lookup formula but to each his own.

--
Jim
| Hi
|
| Realise I can use a VLookup for this but is there a way of returning
| the selected value from a combo on a worksheet as opposed to the
| index.
|
| For instance a cbo populated by ted, bob, john returns '2' into the
| link cell if 'bob' is selected. Is there a way of returning the actual
| value?
|
| Thanks
|
| Mick
|

 

[Dave Peterson]

If the list to populate the dropdown is A1:A10 and the linked cell is B1, you
could use a formula in C1 to get the value:

=if(b1=0,"",index(a1:a10,b1))

But maybe this is equivalent to your =vlookup()???????