lookup and populate with adjacent contents
 

Hi! I've got multiple indiv. company worksheets, a summary worksheet, and a
"lookup worksheet" that lists reps, mgrs, and codes. Currently, the cells of
the summary worksheet are linked to each of the indiv. company sheets. Each
code on the company worksheets is included on the lookup worksheet. I'd like
to have the corresponding mgr and rep data auto-populate to the summary
sheet.

The summary code cell link to the individual sheet is =ABC!$D$1. The
individual code cell link to the lookup is =Lookup!A2. B2 has the mgr data
and C2 has the rep data.

Your help is GREATLY appreciated!!!

lookup and populate with adjacent contents
 

Correction! The individual code should not be linked to the Lookup sheet.
Users will enter this value. I want to set up a lookup on the summary sheet.
Sorry for the confusion.

"Giggly4g" wrote:

Hi! I've got multiple indiv. company worksheets, a summary worksheet, and a
"lookup worksheet" that lists reps, mgrs, and codes. Currently, the cells of
the summary worksheet are linked to each of the indiv. company sheets. Each
code on the company worksheets is included on the lookup worksheet. I'd like
to have the corresponding mgr and rep data auto-populate to the summary
sheet.

The summary code cell link to the individual sheet is =ABC!$D$1. The
individual code cell link to the lookup is =Lookup!A2. B2 has the mgr data
and C2 has the rep data.

Your help is GREATLY appreciated!!!

lookup and populate with adjacent contents
 

Nevermind. I actually figured this one out on my own. Guess it doesn't pay to
try and work when I'm ill.

"Giggly4g" wrote:

Correction! The individual code should not be linked to the Lookup sheet.
Users will enter this value. I want to set up a lookup on the summary sheet.
Sorry for the confusion.

"Giggly4g" wrote:

Hi! I've got multiple indiv. company worksheets, a summary worksheet, and a
"lookup worksheet" that lists reps, mgrs, and codes. Currently, the cells of
the summary worksheet are linked to each of the indiv. company sheets. Each
code on the company worksheets is included on the lookup worksheet. I'd like
to have the corresponding mgr and rep data auto-populate to the summary
sheet.

The summary code cell link to the individual sheet is =ABC!$D$1. The
individual code cell link to the lookup is =Lookup!A2. B2 has the mgr data
and C2 has the rep data.

Your help is GREATLY appreciated!!!