Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have two worksheets. They are both identical with an exception of on column
which is on my summary table. The tables are as follows: data table: job_no; patient; hospital; fault; req_date; rec_date; This table contains all the records from every job we have received. summary table: job_no; patient; hospital; fault; req_date; rec_date; ACTION; This table contains a sample of the data in the 'data table'. I add actions to each job on this table. I need to know how to create a lookup so it will take the ACTION from the 'summary table' and add it into a new column in the 'data table'. it should only add the action if there is an action and the jobs_no in both tables match as this field is unique. any help would be appreciated |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Anyone Else Use Database Query to Query Another Sheet in the Same | Excel Discussion (Misc queries) | |||
AHHH! Again | Excel Discussion (Misc queries) | |||
Web Query Help... | Excel Discussion (Misc queries) | |||
"Query cannot be edited by the Query Wizard" | Excel Discussion (Misc queries) | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) |