List Info

Thread: Linking formulas to list




Linking formulas to list
country flaguser name
United Kingdom
2007-04-18 05:41:30
Hi,

 

I want to give the users of a spreadsheet a list (I'm
thinking combo
box, but not too sure if this is the best way of doing
this).

 

And I want the cell next to it to pull in data depending on
the
selection from the list.  

 

I thought this would be a simple IF function linking to the
combo box,
but for some reason the IF function doesn't like finding my
combo box.

 

All help greatly appreciated

 

Ian Johnson

Financial Controller

Studsvik UK Ltd

 


------------------------------------------------------------
--------------
The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
international's LISTSERV(R) software.  For
subscription/signoff info
and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
                             COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G

[1]

about | contact  Other archives ( Real Estate discussion Medical topics )