Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Christopher Buxton
 
Posts: n/a
Default look up query

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Anyone Else Use Database Query to Query Another Sheet in the Same Ron Coderre Excel Discussion (Misc queries) 0 November 28th 05 06:16 PM
AHHH! Again JAA149 Excel Discussion (Misc queries) 0 October 31st 05 11:36 AM
Web Query Help... Jambruins Excel Discussion (Misc queries) 1 July 29th 05 06:56 PM
"Query cannot be edited by the Query Wizard" PancakeBatter Excel Discussion (Misc queries) 0 April 25th 05 05:59 PM
How to use a Access Query that as a parameter into Excel database query Karen Middleton Excel Discussion (Misc queries) 1 December 13th 04 07:54 PM


All times are GMT +1. The time now is 09:33 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"