Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I realize that this is a trivial question, but at the moment I'm lacking the
necessary patience to sift through help to find out how to accomplish my goal. So here goes: I am trying to set up a quote sheet in Excel in which I enter a product ID# in one column, and the description, list price, and invoice price all fill in based on a table or database that I build with the necessary info. I know I've done something similar to this before, but now I'm at a loss to recall how I managed it. Thanks. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Shaun
Take a look at vlookup HTH "ShaunR1967" wrote: I realize that this is a trivial question, but at the moment I'm lacking the necessary patience to sift through help to find out how to accomplish my goal. So here goes: I am trying to set up a quote sheet in Excel in which I enter a product ID# in one column, and the description, list price, and invoice price all fill in based on a table or database that I build with the necessary info. I know I've done something similar to this before, but now I'm at a loss to recall how I managed it. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Format a chart to automatically update with last 26 data points? | Charts and Charting in Excel | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
DELETE DUPLICATE DATA IN A SHEET AUTOMATICALLY | Excel Discussion (Misc queries) | |||
Pasting data without the worksheet automatically delimiting it? | Excel Discussion (Misc queries) |