Excel Formula

[Guest]

I have a spreadsheet with two worksheets - "Data Entry" and "Summary Data". I need a formula for the following:

If any cell in "Data Entry", column "I" has a number that is equal to the number in "Summary Data", column "A", I want the date in "Data Entry" column "J" that corresponds to the number in column "I" to populate "Summary Data" column "B" next to the same number in "Summary Data" column "A".

Example:
(Data Entry worksheet)
(Column I) (Column J)
Batch Number Batch Date
600 1/6/04
[BLANK] [BLANK]
[BLANK] [BLANK]
[BLANK] [BLANK]
601 1/8/04

(Summary Data worksheet)
(Column A) (Column B)
Batch Number Batch Date
600 <Date from Data Entry J2>
601 <Date from Data Entry J6>
602 <Date from Data Entry J18>
603 <Date from Data Entry J20>
604

 

[mzehr]

Hi Bugman,

You could use an Advanced Filter with the criteria range
set to Batch Date >1, copy to another location = Summary
Data!A1

HTH

-----Original Message-----
I have a spreadsheet with two worksheets - "Data Entry"

and "Summary Data". I need a formula for the following:

If any cell in "Data Entry", column "I" has a number that

is equal to the number in "Summary Data", column "A", I
want the date in "Data Entry" column "J" that corresponds
to the number in column "I" to populate "Summary Data"
column "B" next to the same number in "Summary Data"
column "A".

Example:
(Data Entry worksheet)
(Column I) (Column J)
Batch Number Batch Date
600 1/6/04
[BLANK] [BLANK]
[BLANK] [BLANK]
[BLANK] [BLANK]
601 1/8/04

(Summary Data worksheet)
(Column A) (Column B)
Batch Number Batch Date
600 <Date from Data Entry J2>
601 <Date from Data Entry J6>
602 <Date from Data Entry J18>
603 <Date from Data Entry J20>
604


.

 

[jeff]

Hi,

Or try this:

=VLOOKUP(A2,'Data Entry'!I$2:J$4,2,TRUE)

where A2 has your first lookup value (600) and
your lookup range is on Data Entry sheet cells
I2:J4.

jeff

-----Original Message-----
I have a spreadsheet with two worksheets - "Data Entry"

and "Summary Data". I need a formula for the following:

If any cell in "Data Entry", column "I" has a number

that is equal to the number in "Summary Data",
column "A", I want the date in "Data Entry" column "J"
that corresponds to the number in column "I" to
populate "Summary Data" column "B" next to the same
number in "Summary Data" column "A".

Example:
(Data Entry worksheet)
(Column I) (Column J)
Batch Number Batch Date
600 1/6/04
[BLANK] [BLANK]
[BLANK] [BLANK]
[BLANK] [BLANK]
601 1/8/04

(Summary Data worksheet)
(Column A) (Column B)
Batch Number Batch Date
600 <Date from Data Entry J2>
601 <Date from Data Entry J6>
602 <Date from Data Entry J18>
603 <Date from Data Entry J20>
604


.