Does anyone know how to cross reference two worksheets
You will need to give a bit more detail than this on what you want to
achieve. Which "box" do you refer to? How is your data laid out? Which
column(s) would contain the names? etc.
As a general note, you can have a MATCH formula in a column on one
sheet which looks at the other sheet for an exact match, and a similar
formula in the other sheet to look at the first sheet, so against each
name you can return a "Y" if there is a match - is this what you want?
Pete
On Jan 9, 12:56*am, Christie
wrote:
I am trying to cross reference two worksheet and if a name appears on both
worksheets a Y would appear in the box.
Can anyone help??
|