Use list date for pricing template

N

Nacaha

Version: 2004
Operating System: Mac OS X 10.4 (Tiger)

I have created a product/price list and would like to use data when creating a quote from a template form without having to retype in all of the information from the list.
 
C

CyberTaz

With no more detail than you've supplied my initial thought would be that
you'll wan to look into the HLOOKUP & VLOOKUP functions. They will retrieve
info from a table of data based on a lookup cell that contains a numerical
identifier, such as a part number.

HTH |:>)
Bob Jones
[MVP] Office:Mac
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sorting personal templates alphabetically in Office 365 for mac OS? 3
Custom Chart Templates Gone?? 1
Applescript save as Unicode question 0
Proper formula 3
order forms 3
sorting 2
function to randomly insert text from a given list 2
cell display 2

Top