Cross Referencing in Excel

  • Thread starter Thread starter Marie Tushar
  • Start date Start date
M

Marie Tushar

I am not sure what feature to use for my project:

I have an excel spreadsheet that contains names of
companys, address, individual names, etc. that are broken
by columns.

I would like to set up a function (?) that can
automatically identify the company when I select a cell
that contains an individual's name. In other words, cross
reference from the cell containing a name to the company
listed in the report.

Can this be done?? Or is there another feature I should
look at for this type of project?
 
Marie
This can be done using one of the various Lookup functions. The most commonly used is probably VLOOKUP, but this requires that the data to be returned is in a column to the right of the column in which the search criteria is located. You will probably be able to use the LOOKUP function

Sample

=LOOKUP(A1,Sheet2!D2:D10,Sheet2!A2:A10

A1 is the cell containing the name you want to find
Sheet2!D2:D10 is the group of cell containing the name in your tabl
Sheet2!A2:A10 is the group of cells containing the company names you wish to return

Hopefully this will get you started

Good Luck
Mark Graesse
(e-mail address removed)

----- Marie Tushar wrote: ----

I am not sure what feature to use for my project

I have an excel spreadsheet that contains names of
companys, address, individual names, etc. that are broken
by columns

I would like to set up a function (?) that can
automatically identify the company when I select a cell
that contains an individual's name. In other words, cross
reference from the cell containing a name to the company
listed in the report

Can this be done?? Or is there another feature I should
look at for this type of project
 
Back
Top