Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Lookup Help
I have a small database of customers and products. I am
using this database to compose quotes and invoices. I have quite a few products and would like to be able to enter the product number and have the description and unit price entered automatically. I have never done this before and have searched the internet on how to do this, but have come up empty. I was wondering if someone could explain to me (in pretty basic terms) how to go about doing this. It seems as though I may be making this more difficult than it is. Thanks for the help in advance. P.S. I would also be willing to email a small sample file to someone if they would think that this would make things easier. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Lookup Help
You should use the VLOOKUP function. E.g.,
=VLOOKUP(product_number,database_range,column,FALS E) See help for VLOOKUP for more information. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "dyowell" wrote in message ... I have a small database of customers and products. I am using this database to compose quotes and invoices. I have quite a few products and would like to be able to enter the product number and have the description and unit price entered automatically. I have never done this before and have searched the internet on how to do this, but have come up empty. I was wondering if someone could explain to me (in pretty basic terms) how to go about doing this. It seems as though I may be making this more difficult than it is. Thanks for the help in advance. P.S. I would also be willing to email a small sample file to someone if they would think that this would make things easier. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Lookup Help
Hi
if you'ld like to email me direct (julied_ng at hcts dot net do au) i can send you a workbook that does this ... you can then customise it as you wish. Cheers JulieD "dyowell" wrote in message ... I have a small database of customers and products. I am using this database to compose quotes and invoices. I have quite a few products and would like to be able to enter the product number and have the description and unit price entered automatically. I have never done this before and have searched the internet on how to do this, but have come up empty. I was wondering if someone could explain to me (in pretty basic terms) how to go about doing this. It seems as though I may be making this more difficult than it is. Thanks for the help in advance. P.S. I would also be willing to email a small sample file to someone if they would think that this would make things easier. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
lookup help. lookup result based on data in 2 columns | Excel Worksheet Functions | |||
LOOKUP FUNCTION? (LOOKUP VALUE BEING A TIME RENERATED FROM A FORMU | Excel Discussion (Misc queries) | |||
Matrix lookup/mulitple criteria lookup | Excel Discussion (Misc queries) | |||
Join 2 Lists - Lookup value in 1 list & use result in 2nd lookup | Excel Worksheet Functions | |||
Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) |