Lookup & Give Specified Info. in Specified column
 

Hi,

I have a file with 2 worksheets in it. The first worksheet, provides a
list of charge numbers under a specified program. The second worksheet I am
using for as a timesheet template.

In the second worksheet, I created a list in one of the columns which
finds the list of charge numbers from the first worksheet. What I would like
to happen is once I pick one of these charge numbers, the next 2 or 3 columns
"automatically" pull relavant information from the first worksheet & insert
to specified cell.

For example:

Worksheet 1 - Tracking Charge # Sheet

Column 1 Column 2 Column 3
Charge # PO XYZ Status

1234 PO 4444 Active

Worksheet 2 - Timesheet


Column 1 Column 2 Column 3 Task
Charge # PO XYZ Status

Pick from list Pulls Info. from 1st
Job 1
of Column 1 from worksheet
(Attempting to

tracking that Job 1 is

being billed or

charged to its

correct charge number


I attempted a handful of formulas so far, but none of them seem to fully
work yet.

Please assist.


Thank you....

Lookup & Give Specified Info. in Specified column
 

You should always post the formula/s that you attempted along with your
descriptions. These would provide responders with supportive, vital clues on
your set-up/issue.

Anyway, it sounds like index/match could be an option for you

Assume source data in Sheet1's cols A to C, with key col = col A (charge#)
In Sheet2,
You have the charge#s listed in A2 down
Put in B2:
=IF(ISNA(MATCH($A2,Sheet1!$A:$A,0)),"",(INDEX(Shee t1!B:B,MATCH($A2,Sheet1!$A:$A,0))))
Copy B2 to C2, fill down to populate
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Jason" wrote:
I have a file with 2 worksheets in it. The first worksheet, provides a
list of charge numbers under a specified program. The second worksheet I am
using for as a timesheet template.

In the second worksheet, I created a list in one of the columns which
finds the list of charge numbers from the first worksheet. What I would like
to happen is once I pick one of these charge numbers, the next 2 or 3 columns
"automatically" pull relavant information from the first worksheet & insert
to specified cell.

For example:

Worksheet 1 - Tracking Charge # Sheet

Column 1 Column 2 Column 3
Charge # PO XYZ Status

1234 PO 4444 Active

Worksheet 2 - Timesheet


Column 1 Column 2 Column 3 Task
Charge # PO XYZ Status

Pick from list Pulls Info. from 1st
Job 1
of Column 1 from worksheet
(Attempting to

tracking that Job 1 is

being billed or

charged to its

correct charge number


I attempted a handful of formulas so far, but none of them seem to fully
work yet.

Please assist.


Thank you....