Excel Formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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"
Click to expand...
and "Summary Data". I need a formula for the following:
If any cell in "Data Entry", column "I" has a number that
Click to expand...
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


.
Click to expand...
 
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"
Click to expand...
and "Summary Data". I need a formula for the following:
If any cell in "Data Entry", column "I" has a number
Click to expand...
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


.
Click to expand...
 
Back
Top