I am trying to creat a price sheet such that when any part number is shown
it is assigned the proper price.

ie Part No. Price
XY $5.50
Ab $2.20

I've tried this with the if function but always come up with #Value!

Drum626, have a look at vlookup in help, I think it will do what you want to
do
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Drum6226" wrote in message
...
I am trying to creat a price sheet such that when any part number is shown
it is assigned the proper price.

ie Part No. Price
XY $5.50
Ab $2.20

I've tried this with the if function but always come up with #Value!

Thanks,I was unaware of this or the hlookup function.

"Paul B" wrote:

Drum626, have a look at vlookup in help, I think it will do what you want to
do
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Drum6226" wrote in message
...
I am trying to creat a price sheet such that when any part number is shown
it is assigned the proper price.

ie Part No. Price
XY $5.50
Ab $2.20

I've tried this with the if function but always come up with #Value!