If you are looking to create a drop down list to choose from select the cell
or cells where the validation needs to take place. Go to Data - Vaidation -
Settings. Change Allow to List and then select the list you wannt to use
"T. Valko" wrote:
See these:
How to setup a lookup table:
http://contextures.com/xlFunctions02.html
How to setup a drop down list:
http://contextures.com/xlVideos07.html#DataVal01
--
Biff
Microsoft Excel MVP
"Richard" <Richard @discussions.microsoft.com wrote in message
...
Hi Everyone,
I am trying to do a simply lookup table, but its been years since i have
done it and can't remember.
i want the excel to give me a dropdown of tariffs and it fills in the
customer price adn company GP? it sounds simple but i can not get it
working.
Thanks in advance