I will try to make this easy to understand, or atleast as much as possiable.

What I am trying to do is make a Sales Quote for send to customers. I have
most of what I am wanting to do done on it. But the one thing that I would
like to do, I haven't quite figured out yet.

Basicly, I want to make my life easier when I do a quote. Right now I have
to open another spreadsheet with my prices and look everything up.

So, what I want to do is for me to just type in an item number and excel
goes and looks it up. Either in the same book or different one, it doesn't
matter. And fill in the price's where it needs to be filled in at.

Hopefully I have made it clear enough to understand what I am asking for.

Thanks,