Abi
Post a sample(not a file) of your data layout and the VLOOKUP formula used.
Gord Dibben Excel MVP
On Thu, 6 Jan 2005 13:49:03 -0800, Abi wrote:
I've been wondering about this problem also, and I've tried both suggestions
and get #VALUE!
What am I missing?
"Ken Wright" wrote:
Take a look at VLOOKUP. You create a table with all the matching values and
then use the VLOOKUP formula where you want the prices to appear.
--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------
"wandering" wrote in message
...
I want to associate typed words and monetary values so that I don't have
to
continually retype the price. Is there a table that I can set up that a
template or document draws from?? An example would be that everytime I
type:
PSL 3.5 x 9.5 it would bring up $9.25 into a specific field for further
computation.
|