Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
look up query
Hi Christopher,
Assuming the second worksheet is named Sheet2, enter the following into Cell H1 of the first worksheet (or H2 if you have a header row) and copy the formula down. If you have a header row, you need to change the A1's in the formula to A2's. =IF(VLOOKUP(A1,Sheet2!$A:$H,8,FALSE)=0,"",VLOOKUP( A1,Sheet2!$A:$H,8,FALSE)) HTH -- Ken Hudson "Christopher Buxton" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |